2025-07-28 10:39:57,279 [ 95885 ] INFO : ClickHouse root is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse (runner:53, check_args_and_update_paths) 2025-07-28 10:39:57,280 [ 95885 ] INFO : Cases dir is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration (runner:79, check_args_and_update_paths) 2025-07-28 10:39:57,280 [ 95885 ] INFO : utils dir is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse/utils (runner:90, check_args_and_update_paths) 2025-07-28 10:39:57,280 [ 95885 ] INFO : base_configs_dir: /home/ubuntu/_work/ClickHouse/ClickHouse/programs/server, binary: /home/ubuntu/_work/_temp/test/build/clickhouse, cases_dir: /home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration (runner:92, check_args_and_update_paths) clickhouse_integration_tests_volume Running pytest container as: 'docker run --rm --name clickhouse_integration_tests_tda2mg --privileged --dns-search='.' --memory=30709030912 --security-opt seccomp=unconfined --cap-add=SYS_PTRACE --volume=/home/ubuntu/_work/_temp/test/build/clickhouse:/clickhouse --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/programs/server:/clickhouse-config --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration:/ClickHouse/tests/integration --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/backupview:/ClickHouse/utils/backupview --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/grpc-client/pb2:/ClickHouse/utils/grpc-client/pb2 --volume=/run:/run/host:ro --volume=clickhouse_integration_tests_volume:/var/lib/docker -e DOCKER_DOTNET_CLIENT_TAG=11de0b29a15d -e DOCKER_HELPER_TAG=5dc43a6382f0 -e DOCKER_BASE_TAG=5ccda723c1fc -e DOCKER_KERBEROS_KDC_TAG=9391ecdee8d7 -e DOCKER_MYSQL_GOLANG_CLIENT_TAG=9bec2a638e6e -e DOCKER_MYSQL_JAVA_CLIENT_TAG=766bff31cfe4 -e DOCKER_MYSQL_JS_CLIENT_TAG=41ba7c2ec2a1 -e DOCKER_MYSQL_PHP_CLIENT_TAG=88be89c1e3b6 -e DOCKER_NGINX_DAV_TAG=b55ac9cd7519 -e DOCKER_POSTGRESQL_JAVA_CLIENT_TAG=a4eff5c7f4d6 -e DOCKER_PYTHON_BOTTLE_TAG=d862517635bf -e DOCKER_CLIENT_TIMEOUT=300 -e COMPOSE_HTTP_TIMEOUT=600 -e PYTHONUNBUFFERED=1 -e PYTEST_ADDOPTS="--dist=loadfile -n 10 -rfEps --run-id=0 --color=no --durations=0 --report-log=parallel0_0.jsonl --report-log-exclude-logs-on-passed-tests test_allowed_client_hosts/test.py::test_allowed_host test_allowed_client_hosts/test.py::test_denied_host 'test_alter_moving_garbage/test.py::test_alter_moving[False-False]' 'test_alter_moving_garbage/test.py::test_alter_moving[False-True]' 'test_alter_moving_garbage/test.py::test_alter_moving[True-True]' test_alter_moving_garbage/test.py::test_delete_race_leftovers 'test_attach_backup_from_s3_plain/test.py::test_attach_part[compact0]' 'test_attach_backup_from_s3_plain/test.py::test_attach_part[compact1]' 'test_attach_backup_from_s3_plain/test.py::test_attach_part[wide0]' 'test_attach_backup_from_s3_plain/test.py::test_attach_part[wide1]' test_backup_log/test.py::test_backup_log test_backup_restore_new/test_shutdown_wait_backup.py::test_shutdown_wait_backup test_backup_restore_on_cluster/test_cancel_backup.py::test_cancel_backup test_backup_restore_on_cluster/test_cancel_backup.py::test_cancel_restore test_backup_restore_on_cluster/test_cancel_backup.py::test_error_leaves_no_trash test_backup_restore_on_cluster/test_cancel_backup.py::test_long_disconnection_stops_backup test_backup_restore_on_cluster/test_cancel_backup.py::test_short_disconnection_doesnt_stop_backup test_backup_restore_on_cluster/test_cancel_backup.py::test_short_disconnection_doesnt_stop_restore test_backup_restore_on_cluster/test_cancel_backup.py::test_shutdown_cancels_backup test_backward_compatibility/test_aggregate_fixed_key.py::test_two_level_merge test_backward_compatibility/test_convert_ordinary.py::test_convert_ordinary_to_atomic test_backward_compatibility/test_cte_distributed.py::test_cte_distributed test_backward_compatibility/test_ip_types_binary_compatibility.py::test_ip_types_binary_compatibility test_backward_compatibility/test_memory_bound_aggregation.py::test_backward_compatability test_backward_compatibility/test_short_strings_aggregation.py::test_backward_compatability test_buffer_profile/test.py::test_buffer_profile test_buffer_profile/test.py::test_default_profile test_check_table_name_length/test.py::test_backward_compatibility test_check_table_name_length/test.py::test_check_table_name_length test_cleanup_after_start/test.py::test_old_dirs_cleanup test_cluster_discovery/test_auxiliary_keeper.py::test_cluster_discovery_with_auxiliary_keeper_startup_and_stop test_cluster_discovery/test_password.py::test_connect_with_password test_compatibility_merge_tree_settings/test.py::test_check_projections_compatibility test_compatibility_merge_tree_settings/test.py::test_config_overrides_compatibility test_compression_nested_columns/test.py::test_nested_compression_codec test_concurrent_queries_for_user_restriction/test.py::test_exception_message test_concurrent_ttl_merges/test.py::test_limited_ttl_merges_in_empty_pool test_concurrent_ttl_merges/test.py::test_limited_ttl_merges_in_empty_pool_replicated test_concurrent_ttl_merges/test.py::test_limited_ttl_merges_two_replicas test_concurrent_ttl_merges/test.py::test_no_ttl_merges_in_busy_pool test_config_reloader_interval/test.py::test_reload_config test_config_xml_main/test.py::test_xml_main_conf test_config_yaml_merge_keys/test.py::test_yaml_merge_keys_conf 'test_cow_policy/test.py::test_cow_policy[cow_policy_multi_disk]' 'test_cow_policy/test.py::test_cow_policy[cow_policy_multi_volume]' test_custom_settings/test.py::test_custom_settings test_custom_settings/test.py::test_illformed_setting test_ddl_alter_query/test.py::test_alter test_ddl_alter_query/test.py::test_ddl_queue_hostname_change test_ddl_worker_replicas/test.py::test_ddl_worker_replicas test_default_role/test.py::test_alter_user test_default_role/test.py::test_set_default_roles test_default_role/test.py::test_wrong_set_default_role 'test_dictionaries_all_layouts_separate_sources/test_executable_cache.py::test_complex[complex_key_cache]' 'test_dictionaries_all_layouts_separate_sources/test_executable_cache.py::test_simple[cache]' 'test_dictionaries_all_layouts_separate_sources/test_http.py::test_complex[complex_key_cache]' 'test_dictionaries_all_layouts_separate_sources/test_http.py::test_complex[complex_key_direct]' 'test_dictionaries_all_layouts_separate_sources/test_http.py::test_complex[complex_key_hashed]' 'test_dictionaries_all_layouts_separate_sources/test_http.py::test_ranged[range_hashed]' 'test_dictionaries_all_layouts_separate_sources/test_http.py::test_simple[cache]' 'test_dictionaries_all_layouts_separate_sources/test_http.py::test_simple[direct]' 'test_dictionaries_all_layouts_separate_sources/test_http.py::test_simple[flat]' 'test_dictionaries_all_layouts_separate_sources/test_http.py::test_simple[hashed]' test_dictionaries_mysql/test.py::test_background_dictionary_reconnect test_dictionaries_mysql/test.py::test_mysql_dictionaries_custom_query_full_load test_dictionaries_mysql/test.py::test_mysql_dictionaries_custom_query_partial_load_complex_key test_dictionaries_mysql/test.py::test_mysql_dictionaries_custom_query_partial_load_simple_key test_dictionaries_mysql/test.py::test_predefined_connection_configuration 'test_dictionaries_select_all/test.py::test_select_all[clickhouse_complex_integers_key_hashed]' 'test_dictionaries_select_all/test.py::test_select_all[clickhouse_complex_mixed_key_hashed]' 'test_dictionaries_select_all/test.py::test_select_all[clickhouse_flat]' 'test_dictionaries_select_all/test.py::test_select_all[clickhouse_hashed]' 'test_dictionaries_select_all/test.py::test_select_all[clickhouse_range_hashed]' 'test_dictionaries_select_all/test.py::test_select_all_from_cached[clickhouse_cache]' 'test_dictionaries_select_all/test.py::test_select_all_from_cached[clickhouse_complex_integers_key_cache]' 'test_dictionaries_select_all/test.py::test_select_all_from_cached[clickhouse_complex_mixed_key_cache]' test_disk_types/test.py::test_different_types test_disk_types/test.py::test_select_by_type test_disks_app_interactive/test.py::test_disks_app_interactive_cp_and_read test_disks_app_interactive/test.py::test_disks_app_interactive_list_directories_default test_disks_app_interactive/test.py::test_disks_app_interactive_list_disks test_disks_app_interactive/test.py::test_disks_app_interactive_list_files_local test_disks_app_interactive/test.py::test_disks_app_interactive_test_move_and_write test_distributed_inter_server_secret/test.py::test_insecure test_distributed_inter_server_secret/test.py::test_insecure_insert_async test_distributed_inter_server_secret/test.py::test_insecure_insert_sync 'test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_insecure_cluster[default-]' 'test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_insecure_cluster[nopass-]' 'test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_insecure_cluster[pass-foo]' 'test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_secure_cluster[default-]' 'test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_secure_cluster[nopass-]' 'test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_secure_cluster[pass-foo]' 'test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_insecure_cluster[default-]' 'test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_insecure_cluster[nopass-]' 'test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_insecure_cluster[pass-foo]' 'test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_secure_cluster[default-]' 'test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_secure_cluster[nopass-]' 'test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_secure_cluster[pass-foo]' test_distributed_inter_server_secret/test.py::test_secure test_distributed_inter_server_secret/test.py::test_secure_cluster_distributed_over_distributed_different_users_cluster -vvv " altinityinfra/integration-tests-runner:226bfaf75ac1 '. Start tests ============================= test session starts ============================== platform linux -- Python 3.10.12, pytest-7.4.4, pluggy-1.5.0 -- /usr/bin/python3 cachedir: .pytest_cache Test order randomisation NOT enabled. Enable with --random-order or --random-order-bucket= rootdir: /ClickHouse/tests/integration configfile: pytest.ini plugins: timeout-2.3.1, repeat-0.9.3, order-1.0.0, reportlog-0.4.0, xdist-3.5.0, random-order-1.1.1 timeout: 900.0s timeout method: signal timeout func_only: False created: 10/10 workers 10 workers [100 items] scheduling tests via LoadFileScheduling test_dictionaries_mysql/test.py::test_background_dictionary_reconnect test_distributed_inter_server_secret/test.py::test_insecure test_concurrent_ttl_merges/test.py::test_limited_ttl_merges_in_empty_pool test_dictionaries_select_all/test.py::test_select_all[clickhouse_complex_integers_key_hashed] test_dictionaries_all_layouts_separate_sources/test_http.py::test_complex[complex_key_cache] test_attach_backup_from_s3_plain/test.py::test_attach_part[compact0] test_alter_moving_garbage/test.py::test_alter_moving[False-False] test_backup_restore_on_cluster/test_cancel_backup.py::test_cancel_backup test_disks_app_interactive/test.py::test_disks_app_interactive_cp_and_read test_default_role/test.py::test_alter_user [gw7] [ 1%] PASSED test_disks_app_interactive/test.py::test_disks_app_interactive_cp_and_read test_disks_app_interactive/test.py::test_disks_app_interactive_list_directories_default [gw7] [ 2%] PASSED test_disks_app_interactive/test.py::test_disks_app_interactive_list_directories_default test_disks_app_interactive/test.py::test_disks_app_interactive_list_disks [gw7] [ 3%] PASSED test_disks_app_interactive/test.py::test_disks_app_interactive_list_disks test_disks_app_interactive/test.py::test_disks_app_interactive_list_files_local [gw7] [ 4%] PASSED test_disks_app_interactive/test.py::test_disks_app_interactive_list_files_local test_disks_app_interactive/test.py::test_disks_app_interactive_test_move_and_write [gw7] [ 5%] PASSED test_disks_app_interactive/test.py::test_disks_app_interactive_test_move_and_write test_allowed_client_hosts/test.py::test_allowed_host [gw2] [ 6%] PASSED test_dictionaries_select_all/test.py::test_select_all[clickhouse_complex_integers_key_hashed] test_dictionaries_select_all/test.py::test_select_all[clickhouse_complex_mixed_key_hashed] [gw2] [ 7%] PASSED test_dictionaries_select_all/test.py::test_select_all[clickhouse_complex_mixed_key_hashed] test_dictionaries_select_all/test.py::test_select_all[clickhouse_flat] [gw9] [ 8%] PASSED test_default_role/test.py::test_alter_user test_default_role/test.py::test_set_default_roles [gw2] [ 9%] PASSED test_dictionaries_select_all/test.py::test_select_all[clickhouse_flat] test_dictionaries_select_all/test.py::test_select_all[clickhouse_hashed] [gw2] [ 10%] PASSED test_dictionaries_select_all/test.py::test_select_all[clickhouse_hashed] test_dictionaries_select_all/test.py::test_select_all[clickhouse_range_hashed] [gw6] [ 11%] PASSED test_attach_backup_from_s3_plain/test.py::test_attach_part[compact0] test_attach_backup_from_s3_plain/test.py::test_attach_part[compact1] [gw2] [ 12%] PASSED test_dictionaries_select_all/test.py::test_select_all[clickhouse_range_hashed] test_dictionaries_select_all/test.py::test_select_all_from_cached[clickhouse_cache] [gw6] [ 13%] PASSED test_attach_backup_from_s3_plain/test.py::test_attach_part[compact1] test_attach_backup_from_s3_plain/test.py::test_attach_part[wide0] [gw9] [ 14%] PASSED test_default_role/test.py::test_set_default_roles test_default_role/test.py::test_wrong_set_default_role [gw6] [ 15%] PASSED test_attach_backup_from_s3_plain/test.py::test_attach_part[wide0] test_attach_backup_from_s3_plain/test.py::test_attach_part[wide1] [gw2] [ 16%] PASSED test_dictionaries_select_all/test.py::test_select_all_from_cached[clickhouse_cache] test_dictionaries_select_all/test.py::test_select_all_from_cached[clickhouse_complex_integers_key_cache] [gw9] [ 17%] PASSED test_default_role/test.py::test_wrong_set_default_role [gw6] [ 18%] PASSED test_attach_backup_from_s3_plain/test.py::test_attach_part[wide1] [gw2] [ 19%] PASSED test_dictionaries_select_all/test.py::test_select_all_from_cached[clickhouse_complex_integers_key_cache] test_dictionaries_select_all/test.py::test_select_all_from_cached[clickhouse_complex_mixed_key_cache] [gw7] [ 20%] PASSED test_allowed_client_hosts/test.py::test_allowed_host test_allowed_client_hosts/test.py::test_denied_host [gw2] [ 21%] PASSED test_dictionaries_select_all/test.py::test_select_all_from_cached[clickhouse_complex_mixed_key_cache] [gw7] [ 22%] PASSED test_allowed_client_hosts/test.py::test_denied_host test_check_table_name_length/test.py::test_backward_compatibility test_cow_policy/test.py::test_cow_policy[cow_policy_multi_disk] [gw1] [ 23%] PASSED test_distributed_inter_server_secret/test.py::test_insecure test_distributed_inter_server_secret/test.py::test_insecure_insert_async test_buffer_profile/test.py::test_buffer_profile [gw3] [ 24%] PASSED test_backup_restore_on_cluster/test_cancel_backup.py::test_cancel_backup test_backup_restore_on_cluster/test_cancel_backup.py::test_cancel_restore [gw1] [ 25%] PASSED test_distributed_inter_server_secret/test.py::test_insecure_insert_async test_distributed_inter_server_secret/test.py::test_insecure_insert_sync [gw5] [ 26%] PASSED test_alter_moving_garbage/test.py::test_alter_moving[False-False] test_alter_moving_garbage/test.py::test_alter_moving[False-True] [gw8] [ 27%] PASSED test_concurrent_ttl_merges/test.py::test_limited_ttl_merges_in_empty_pool test_concurrent_ttl_merges/test.py::test_limited_ttl_merges_in_empty_pool_replicated [gw0] [ 28%] PASSED test_dictionaries_all_layouts_separate_sources/test_http.py::test_complex[complex_key_cache] test_dictionaries_all_layouts_separate_sources/test_http.py::test_complex[complex_key_direct] [gw1] [ 29%] PASSED test_distributed_inter_server_secret/test.py::test_insecure_insert_sync test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_insecure_cluster[default-] [gw1] [ 30%] PASSED test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_insecure_cluster[default-] test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_insecure_cluster[nopass-] [gw1] [ 31%] PASSED test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_insecure_cluster[nopass-] test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_insecure_cluster[pass-foo] [gw1] [ 32%] PASSED test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_insecure_cluster[pass-foo] test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_secure_cluster[default-] [gw1] [ 33%] PASSED test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_secure_cluster[default-] test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_secure_cluster[nopass-] [gw1] [ 34%] PASSED test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_secure_cluster[nopass-] test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_secure_cluster[pass-foo] [gw1] [ 35%] PASSED test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_secure_cluster[pass-foo] test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_insecure_cluster[default-] [gw1] [ 36%] PASSED test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_insecure_cluster[default-] test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_insecure_cluster[nopass-] [gw1] [ 37%] PASSED test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_insecure_cluster[nopass-] test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_insecure_cluster[pass-foo] [gw1] [ 38%] PASSED test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_insecure_cluster[pass-foo] test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_secure_cluster[default-] [gw1] [ 39%] PASSED test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_secure_cluster[default-] test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_secure_cluster[nopass-] [gw1] [ 40%] PASSED test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_secure_cluster[nopass-] test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_secure_cluster[pass-foo] [gw1] [ 41%] PASSED test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_secure_cluster[pass-foo] test_distributed_inter_server_secret/test.py::test_secure [gw1] [ 42%] PASSED test_distributed_inter_server_secret/test.py::test_secure [gw7] [ 43%] PASSED test_buffer_profile/test.py::test_buffer_profile test_buffer_profile/test.py::test_default_profile test_distributed_inter_server_secret/test.py::test_secure_cluster_distributed_over_distributed_different_users_cluster [gw7] [ 44%] PASSED test_buffer_profile/test.py::test_default_profile [gw1] [ 45%] PASSED test_distributed_inter_server_secret/test.py::test_secure_cluster_distributed_over_distributed_different_users_cluster [gw5] [ 46%] PASSED test_alter_moving_garbage/test.py::test_alter_moving[False-True] test_alter_moving_garbage/test.py::test_alter_moving[True-True] [gw4] [ 47%] PASSED test_dictionaries_mysql/test.py::test_background_dictionary_reconnect test_dictionaries_mysql/test.py::test_mysql_dictionaries_custom_query_full_load test_dictionaries_all_layouts_separate_sources/test_executable_cache.py::test_complex[complex_key_cache] [gw4] [ 48%] PASSED test_dictionaries_mysql/test.py::test_mysql_dictionaries_custom_query_full_load test_dictionaries_mysql/test.py::test_mysql_dictionaries_custom_query_partial_load_complex_key [gw4] [ 49%] PASSED test_dictionaries_mysql/test.py::test_mysql_dictionaries_custom_query_partial_load_complex_key test_dictionaries_mysql/test.py::test_mysql_dictionaries_custom_query_partial_load_simple_key [gw4] [ 50%] PASSED test_dictionaries_mysql/test.py::test_mysql_dictionaries_custom_query_partial_load_simple_key test_dictionaries_mysql/test.py::test_predefined_connection_configuration test_compatibility_merge_tree_settings/test.py::test_check_projections_compatibility [gw4] [ 51%] PASSED test_dictionaries_mysql/test.py::test_predefined_connection_configuration [gw5] [ 52%] PASSED test_alter_moving_garbage/test.py::test_alter_moving[True-True] test_alter_moving_garbage/test.py::test_delete_race_leftovers [gw0] [ 53%] PASSED test_dictionaries_all_layouts_separate_sources/test_http.py::test_complex[complex_key_direct] test_dictionaries_all_layouts_separate_sources/test_http.py::test_complex[complex_key_hashed] test_backward_compatibility/test_aggregate_fixed_key.py::test_two_level_merge [gw9] [ 54%] PASSED test_check_table_name_length/test.py::test_backward_compatibility test_check_table_name_length/test.py::test_check_table_name_length [gw9] [ 55%] PASSED test_check_table_name_length/test.py::test_check_table_name_length test_disk_types/test.py::test_different_types test_custom_settings/test.py::test_custom_settings [gw6] [ 56%] PASSED test_compatibility_merge_tree_settings/test.py::test_check_projections_compatibility test_compatibility_merge_tree_settings/test.py::test_config_overrides_compatibility [gw6] [ 57%] PASSED test_compatibility_merge_tree_settings/test.py::test_config_overrides_compatibility [gw0] [ 58%] PASSED test_dictionaries_all_layouts_separate_sources/test_http.py::test_complex[complex_key_hashed] test_dictionaries_all_layouts_separate_sources/test_http.py::test_ranged[range_hashed] [gw3] [ 59%] PASSED test_backup_restore_on_cluster/test_cancel_backup.py::test_cancel_restore test_backup_restore_on_cluster/test_cancel_backup.py::test_error_leaves_no_trash test_backward_compatibility/test_cte_distributed.py::test_cte_distributed [gw9] [ 60%] PASSED test_custom_settings/test.py::test_custom_settings test_custom_settings/test.py::test_illformed_setting [gw9] [ 61%] PASSED test_custom_settings/test.py::test_illformed_setting [gw1] [ 62%] PASSED test_disk_types/test.py::test_different_types test_disk_types/test.py::test_select_by_type [gw4] [ 63%] PASSED test_backward_compatibility/test_aggregate_fixed_key.py::test_two_level_merge [gw1] [ 64%] PASSED test_disk_types/test.py::test_select_by_type [gw0] [ 65%] PASSED test_dictionaries_all_layouts_separate_sources/test_http.py::test_ranged[range_hashed] test_dictionaries_all_layouts_separate_sources/test_http.py::test_simple[cache] [gw3] [ 66%] PASSED test_backup_restore_on_cluster/test_cancel_backup.py::test_error_leaves_no_trash test_backup_restore_on_cluster/test_cancel_backup.py::test_long_disconnection_stops_backup [gw7] [ 67%] PASSED test_dictionaries_all_layouts_separate_sources/test_executable_cache.py::test_complex[complex_key_cache] test_dictionaries_all_layouts_separate_sources/test_executable_cache.py::test_simple[cache] test_cleanup_after_start/test.py::test_old_dirs_cleanup test_backward_compatibility/test_convert_ordinary.py::test_convert_ordinary_to_atomic [gw6] [ 68%] PASSED test_backward_compatibility/test_cte_distributed.py::test_cte_distributed [gw0] [ 69%] PASSED test_dictionaries_all_layouts_separate_sources/test_http.py::test_simple[cache] test_dictionaries_all_layouts_separate_sources/test_http.py::test_simple[direct] test_cluster_discovery/test_auxiliary_keeper.py::test_cluster_discovery_with_auxiliary_keeper_startup_and_stop [gw7] [ 70%] PASSED test_dictionaries_all_layouts_separate_sources/test_executable_cache.py::test_simple[cache] [gw9] [ 71%] PASSED test_cleanup_after_start/test.py::test_old_dirs_cleanup [gw5] [ 72%] PASSED test_alter_moving_garbage/test.py::test_delete_race_leftovers test_backup_restore_new/test_shutdown_wait_backup.py::test_shutdown_wait_backup [gw3] [ 73%] PASSED test_backup_restore_on_cluster/test_cancel_backup.py::test_long_disconnection_stops_backup test_compression_nested_columns/test.py::test_nested_compression_codec test_backup_restore_on_cluster/test_cancel_backup.py::test_short_disconnection_doesnt_stop_backup test_backward_compatibility/test_short_strings_aggregation.py::test_backward_compatability [gw1] [ 74%] PASSED test_backward_compatibility/test_short_strings_aggregation.py::test_backward_compatability test_concurrent_queries_for_user_restriction/test.py::test_exception_message [gw0] [ 75%] PASSED test_dictionaries_all_layouts_separate_sources/test_http.py::test_simple[direct] test_dictionaries_all_layouts_separate_sources/test_http.py::test_simple[flat] [gw9] [ 76%] PASSED test_compression_nested_columns/test.py::test_nested_compression_codec [gw3] [ 77%] PASSED test_backup_restore_on_cluster/test_cancel_backup.py::test_short_disconnection_doesnt_stop_backup test_backup_restore_on_cluster/test_cancel_backup.py::test_short_disconnection_doesnt_stop_restore test_config_xml_main/test.py::test_xml_main_conf [gw8] [ 78%] PASSED test_concurrent_ttl_merges/test.py::test_limited_ttl_merges_in_empty_pool_replicated test_concurrent_ttl_merges/test.py::test_limited_ttl_merges_two_replicas test_backup_log/test.py::test_backup_log [gw1] [ 79%] PASSED test_concurrent_queries_for_user_restriction/test.py::test_exception_message [gw0] [ 80%] PASSED test_dictionaries_all_layouts_separate_sources/test_http.py::test_simple[flat] test_dictionaries_all_layouts_separate_sources/test_http.py::test_simple[hashed] [gw5] [ 81%] PASSED test_backup_log/test.py::test_backup_log [gw9] [ 82%] PASSED test_config_xml_main/test.py::test_xml_main_conf test_backward_compatibility/test_ip_types_binary_compatibility.py::test_ip_types_binary_compatibility [gw3] [ 83%] PASSED test_backup_restore_on_cluster/test_cancel_backup.py::test_short_disconnection_doesnt_stop_restore test_backup_restore_on_cluster/test_cancel_backup.py::test_shutdown_cancels_backup [gw0] [ 84%] PASSED test_dictionaries_all_layouts_separate_sources/test_http.py::test_simple[hashed] [gw3] [ 85%] FAILED test_backup_restore_on_cluster/test_cancel_backup.py::test_shutdown_cancels_backup [gw7] [ 86%] PASSED test_backup_restore_new/test_shutdown_wait_backup.py::test_shutdown_wait_backup [gw5] [ 87%] PASSED test_backward_compatibility/test_ip_types_binary_compatibility.py::test_ip_types_binary_compatibility test_config_reloader_interval/test.py::test_reload_config [gw6] [ 88%] PASSED test_cluster_discovery/test_auxiliary_keeper.py::test_cluster_discovery_with_auxiliary_keeper_startup_and_stop test_cluster_discovery/test_password.py::test_connect_with_password [gw7] [ 89%] PASSED test_config_reloader_interval/test.py::test_reload_config [gw6] [ 90%] PASSED test_cluster_discovery/test_password.py::test_connect_with_password test_ddl_worker_replicas/test.py::test_ddl_worker_replicas [gw4] [ 91%] PASSED test_backward_compatibility/test_convert_ordinary.py::test_convert_ordinary_to_atomic test_backward_compatibility/test_memory_bound_aggregation.py::test_backward_compatability [gw8] [ 92%] PASSED test_concurrent_ttl_merges/test.py::test_limited_ttl_merges_two_replicas test_concurrent_ttl_merges/test.py::test_no_ttl_merges_in_busy_pool [gw8] [ 93%] PASSED test_concurrent_ttl_merges/test.py::test_no_ttl_merges_in_busy_pool [gw4] [ 94%] PASSED test_backward_compatibility/test_memory_bound_aggregation.py::test_backward_compatability test_config_yaml_merge_keys/test.py::test_yaml_merge_keys_conf [gw2] [ 95%] FAILED test_cow_policy/test.py::test_cow_policy[cow_policy_multi_disk] test_cow_policy/test.py::test_cow_policy[cow_policy_multi_volume] [gw4] [ 96%] PASSED test_config_yaml_merge_keys/test.py::test_yaml_merge_keys_conf [gw6] [ 97%] PASSED test_ddl_worker_replicas/test.py::test_ddl_worker_replicas [gw2] [ 98%] FAILED test_cow_policy/test.py::test_cow_policy[cow_policy_multi_volume] test_ddl_alter_query/test.py::test_alter [gw2] [ 99%] PASSED test_ddl_alter_query/test.py::test_alter test_ddl_alter_query/test.py::test_ddl_queue_hostname_change [gw2] [100%] PASSED test_ddl_alter_query/test.py::test_ddl_queue_hostname_change =================================== FAILURES =================================== _________________________ test_shutdown_cancels_backup _________________________ [gw3] linux -- Python 3.10.12 /usr/bin/python3 def test_shutdown_cancels_backup(): > with NoTrashChecker() as no_trash_checker: test_backup_restore_on_cluster/test_cancel_backup.py:556: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ self = type = None, value = None, traceback = None def __exit__(self, type, value, traceback): list_of_znodes = set( node1.query( "SELECT name FROM system.zookeeper WHERE path = '/clickhouse/backups' " + "AND NOT (name == 'alive_tracker')" ).splitlines() ) new_znodes = list_of_znodes.difference(self.__previous_list_of_znodes) if new_znodes: print(f"Found nodes in ZooKeeper: {new_znodes}") for node in new_znodes: print( f"Nodes in '/clickhouse/backups/{node}':\n" + node1.query( f"SELECT name FROM system.zookeeper WHERE path = '/clickhouse/backups/{node}'" ) ) print( f"Nodes in '/clickhouse/backups/{node}/stage':\n" + node1.query( f"SELECT name FROM system.zookeeper WHERE path = '/clickhouse/backups/{node}/stage'" ) ) if self.check_zookeeper: assert new_znodes == set() list_of_backups = set( os.listdir(os.path.join(node1.cluster.instances_dir, "backups")) ) new_backups = list_of_backups.difference(self.__previous_list_of_backups) unfinished_backups = set( backup for backup in new_backups if not os.path.exists( os.path.join(node1.cluster.instances_dir, "backups", backup, ".backup") ) ) new_backups = set( backup for backup in new_backups if backup not in unfinished_backups ) if new_backups: print(f"Found new backups: {new_backups}") if unfinished_backups: print(f"Found unfinished backups: {unfinished_backups}") assert new_backups == set(self.expect_backups) assert unfinished_backups.difference(self.allow_unfinished_backups) == set() all_errors = set() start_time = time.strftime( "%Y-%m-%d %H:%M:%S", self.__start_time_for_collecting_errors ) for node in nodes: errors_query_result = node.query( "SELECT name FROM system.errors WHERE last_error_time >= toDateTime('" + start_time + "') " + "AND NOT ((name == 'KEEPER_EXCEPTION') AND (last_error_message LIKE '%Fault injection%')) " + "AND NOT (name == 'NO_ELEMENTS_IN_CONFIG')" ) errors = errors_query_result.splitlines() if errors: print(f"{get_node_name(node)}: Found errors: {errors}") print( node.query( "SELECT name, last_error_message FROM system.errors WHERE last_error_time >= toDateTime('" + start_time + "')" ) ) for error in errors: > assert (error in self.expect_errors) or (error in self.allow_errors) E AssertionError: assert ('NETLINK_ERROR' in ['QUERY_WAS_CANCELLED'] or 'NETLINK_ERROR' in []) E + where ['QUERY_WAS_CANCELLED'] = .expect_errors E + and [] = .allow_errors test_backup_restore_on_cluster/test_cancel_backup.py:394: AssertionError ----------------------------- Captured stdout call ----------------------------- Using node1 as initiator Sleeping 0.13586311343614565 seconds Waiting for number of system processes = 1+ Got 1 system processes for backup 7d3121388d33402c8fcdea634dbb5c23 after waiting 1 seconds node2: Restarting... node2: Restarted Waiting for number of system processes = 0 Got 0 system processes for backup 7d3121388d33402c8fcdea634dbb5c23 after waiting 0 seconds node1: Found errors: ['QUERY_WAS_CANCELLED'] QUERY_WAS_CANCELLED Got error from host node2:9000. DB::Exception: Query was cancelled. Stack trace:\n\n0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000f52449b\n1. DB::Exception::Exception(PreformattedMessage&&, int) @ 0x0000000009fc506c\n2. DB::Exception::Exception<>(int, FormatStringHelperImpl<>) @ 0x0000000009fd182b\n3. DB::QueryStatus::throwQueryWasCancelled() const @ 0x000000001373db0f\n4. DB::QueryStatus::throwProperExceptionIfNeeded(unsigned long const&, unsigned long const&) @ 0x000000001373da0c\n5. DB::BackupEntriesCollector::setStage(String const&, String const&) @ 0x000000001250771f\n6. DB::BackupEntriesCollector::gatherMetadataAndCheckConsistency() @ 0x0000000012504265\n7. DB::BackupEntriesCollector::run() @ 0x0000000012500a06\n8. DB::BackupsWorker::BackupStarter::doBackup() @ 0x0000000012540141\n9. void std::__function::__policy_invoker::__call_impl[abi:ne190107] const&, std::shared_ptr const&)::$_0, void ()>>(std::__function::__policy_storage const*) @ 0x000000001253de8c\n10. std::__packaged_task_func (std::function&&, Priority)> DB::threadPoolCallbackRunnerUnsafe>(ThreadPoolImpl>&, String const&)::\'lambda\'(std::function&&, Priority)::operator()(std::function&&, Priority)::\'lambda\'(), std::allocator (std::function&&, Priority)> DB::threadPoolCallbackRunnerUnsafe>(ThreadPoolImpl>&, String const&)::\'lambda\'(std::function&&, Priority)::operator()(std::function&&, Priority)::\'lambda\'()>, void ()>::operator()() @ 0x000000001206ad44\n11. std::packaged_task::operator()() @ 0x000000001206aeac\n12. ThreadPoolImpl>::ThreadFromThreadPool::worker() @ 0x000000000f65957b\n13. void std::__function::__policy_invoker::__call_impl[abi:ne190107]::ThreadFromGlobalPoolImpl>::ThreadFromThreadPool::*)(), ThreadPoolImpl>::ThreadFromThreadPool*>(void (ThreadPoolImpl>::ThreadFromThreadPool::*&&)(), ThreadPoolImpl>::ThreadFromThreadPool*&&)::\'lambda\'(), void ()>>(std::__function::__policy_storage const*) @ 0x000000000f6600a3\n14. ThreadPoolImpl::ThreadFromThreadPool::worker() @ 0x000000000f6568af\n15. void* std::__thread_proxy[abi:ne190107]>, void (ThreadPoolImpl::ThreadFromThreadPool::*)(), ThreadPoolImpl::ThreadFromThreadPool*>>(void*) @ 0x000000000f65db7a\n16. ? @ 0x00007feb497c1ac3\n17. ? @ 0x00007feb49853850\n\nJob\'s origin stack trace:\n0. void boost::heap::priority_queue, boost::parameter::void_, boost::parameter::void_, boost::parameter::void_>::emplace, Priority&, StrongTypedef&, DB::OpenTelemetry::TracingContextOnThread const, bool&, (anonymous namespace)::ScopedDecrement>(std::function&&, Priority&, StrongTypedef&, DB::OpenTelemetry::TracingContextOnThread const&&, bool&, (anonymous namespace)::ScopedDecrement&&) @ 0x000000000f65e7b7\n1. void ThreadPoolImpl>::scheduleImpl(std::function, Priority, std::optional, bool) @ 0x000000000f65a958\n2. std::function (std::function&&, Priority)> DB::threadPoolCallbackRunnerUnsafe>(ThreadPoolImpl>&, String const&)::\'lambda\'(std::function&&, Priority)::operator()(std::function&&, Priority) @ 0x000000001206a55a\n3. std::future std::__function::__policy_invoker (std::function&&, Priority)>::__call_impl[abi:ne190107] (std::function&&, Priority)> DB::threadPoolCallbackRunnerUnsafe>(ThreadPoolImpl>&, String const&)::\'lambda\'(std::function&&, Priority), std::future (std::function&&, Priority)>>(std::__function::__policy_storage const*, std::function&&, Priority&&) @ 0x000000001206a38f\n4. DB::BackupsWorker::startMakingBackup(std::shared_ptr const&, std::shared_ptr const&) @ 0x0000000012534cb5\n5. DB::BackupsWorker::start(std::shared_ptr const&, std::shared_ptr) @ 0x0000000012533cc3\n6. DB::InterpreterBackupQuery::execute() @ 0x0000000013a85b04\n7. DB::executeQueryImpl(char const*, char const*, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum, DB::ReadBuffer*, std::shared_ptr&) @ 0x00000000139f96ab\n8. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr, std::function, DB::QueryFlags, std::optional const&, std::function const&, std::optional const&)>) @ 0x00000000139fd9a3\n9. DB::DDLWorker::tryExecuteQuery(DB::DDLTaskBase&, std::shared_ptr const&, bool) @ 0x000000001320ee80\n10. DB::DDLWorker::processTask(DB::DDLTaskBase&, std::shared_ptr const&, bool) @ 0x000000001320d21b\n11. DB::DDLWorker::scheduleTasks(bool) @ 0x0000000013209e42\n12. DB::DDLWorker::runMainThread() @ 0x0000000013201d4c\n13. void std::__function::__policy_invoker::__call_impl[abi:ne190107]::ThreadFromGlobalPoolImpl(void (DB::DDLWorker::*&&)(), DB::DDLWorker*&&)::\'lambda\'(), void ()>>(std::__function::__policy_storage const*) @ 0x0000000013220c63\n14. ThreadPoolImpl::ThreadFromThreadPool::worker() @ 0x000000000f6568af\n15. void* std::__thread_proxy[abi:ne190107]>, void (ThreadPoolImpl::ThreadFromThreadPool::*)(), ThreadPoolImpl::ThreadFromThreadPool*>>(void*) @ 0x000000000f65db7a\n16. ? @ 0x00007feb497c1ac3\n17. ? @ 0x00007feb49853850\n node2: Found errors: ['NETLINK_ERROR'] NO_ELEMENTS_IN_CONFIG Certificate file is not set. NETLINK_ERROR Can\'t receive Netlink response: error -2 ------------------------------ Captured log call ------------------------------- 2025-07-28 10:42:02.167000 [ 653 ] DEBUG : Executing query SELECT name FROM system.zookeeper WHERE path = '/clickhouse/backups' AND NOT (name == 'alive_tracker') on node1 (cluster.py:3648, query) 2025-07-28 10:42:02.283000 [ 653 ] DEBUG : Executing query CREATE TABLE tbl ON CLUSTER 'cluster' (x UInt64) ENGINE=ReplicatedMergeTree('/clickhouse/tables/tbl/', '{replica}') ORDER BY tuple() PARTITION BY x%10 on node2 (cluster.py:3648, query) 2025-07-28 10:42:02.449000 [ 653 ] DEBUG : Executing query INSERT INTO tbl SELECT number FROM numbers(10) on node2 (cluster.py:3648, query) 2025-07-28 10:42:02.616000 [ 653 ] DEBUG : Executing query BACKUP TABLE tbl ON CLUSTER 'cluster' TO Disk('backups', '7d3121388d33402c8fcdea634dbb5c23') SETTINGS id='7d3121388d33402c8fcdea634dbb5c23' ASYNC on node1 (cluster.py:3648, query) 2025-07-28 10:42:02.732000 [ 653 ] DEBUG : Executing query SELECT status FROM system.backups WHERE id='7d3121388d33402c8fcdea634dbb5c23' on node1 (cluster.py:3648, query) 2025-07-28 10:42:02.799000 [ 653 ] DEBUG : Executing query SELECT count() FROM system.processes WHERE (query_kind='Backup') AND (query LIKE '%7d3121388d33402c8fcdea634dbb5c23%') on node1 (cluster.py:3648, query) 2025-07-28 10:42:03.054000 [ 653 ] DEBUG : Executing query SELECT count() FROM system.processes WHERE (query_kind='Backup') AND (query LIKE '%7d3121388d33402c8fcdea634dbb5c23%') on node2 (cluster.py:3648, query) 2025-07-28 10:42:04.141000 [ 653 ] DEBUG : Executing query SELECT count() FROM system.processes WHERE (query_kind='Backup') AND (query LIKE '%7d3121388d33402c8fcdea634dbb5c23%') on node2 (cluster.py:3648, query) 2025-07-28 10:42:04.206000 [ 653 ] DEBUG : run container_id:roottestbackuprestoreonclustercancelbackup-gw3-node2-1 detach:False nothrow:True cmd: ['bash', '-c', 'ps -C clickhouse'] (cluster.py:2051, exec_in_container) 2025-07-28 10:42:04.207000 [ 653 ] DEBUG : Command:[docker exec -u root roottestbackuprestoreonclustercancelbackup-gw3-node2-1 bash -c ps -C clickhouse] (cluster.py:121, run_and_check) 2025-07-28 10:42:04.262000 [ 653 ] DEBUG : Stdout: PID TTY TIME CMD (cluster.py:145, run_and_check) 2025-07-28 10:42:04.263000 [ 653 ] DEBUG : Stdout: 10 ? 00:00:08 clickhouse (cluster.py:145, run_and_check) 2025-07-28 10:42:04.263000 [ 653 ] DEBUG : run container_id:roottestbackuprestoreonclustercancelbackup-gw3-node2-1 detach:False nothrow:False cmd: ['bash', '-c', 'pkill clickhouse'] (cluster.py:2051, exec_in_container) 2025-07-28 10:42:04.263000 [ 653 ] DEBUG : Command:[docker exec -u root roottestbackuprestoreonclustercancelbackup-gw3-node2-1 bash -c pkill clickhouse] (cluster.py:121, run_and_check) 2025-07-28 10:42:04.323000 [ 653 ] DEBUG : run container_id:roottestbackuprestoreonclustercancelbackup-gw3-node2-1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:2051, exec_in_container) 2025-07-28 10:42:04.324000 [ 653 ] DEBUG : Command:[docker exec roottestbackuprestoreonclustercancelbackup-gw3-node2-1 bash -c ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'] (cluster.py:121, run_and_check) 2025-07-28 10:42:04.377000 [ 653 ] DEBUG : Stdout:10 (cluster.py:145, run_and_check) 2025-07-28 10:42:05.379000 [ 653 ] DEBUG : run container_id:roottestbackuprestoreonclustercancelbackup-gw3-node2-1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:2051, exec_in_container) 2025-07-28 10:42:05.380000 [ 653 ] DEBUG : Command:[docker exec roottestbackuprestoreonclustercancelbackup-gw3-node2-1 bash -c ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'] (cluster.py:121, run_and_check) 2025-07-28 10:42:05.436000 [ 653 ] DEBUG : Stdout:10 (cluster.py:145, run_and_check) 2025-07-28 10:42:06.437000 [ 653 ] DEBUG : run container_id:roottestbackuprestoreonclustercancelbackup-gw3-node2-1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:2051, exec_in_container) 2025-07-28 10:42:06.438000 [ 653 ] DEBUG : Command:[docker exec roottestbackuprestoreonclustercancelbackup-gw3-node2-1 bash -c ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'] (cluster.py:121, run_and_check) 2025-07-28 10:42:06.507000 [ 653 ] DEBUG : Stdout:10 (cluster.py:145, run_and_check) 2025-07-28 10:42:07.508000 [ 653 ] DEBUG : run container_id:roottestbackuprestoreonclustercancelbackup-gw3-node2-1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:2051, exec_in_container) 2025-07-28 10:42:07.508000 [ 653 ] DEBUG : Command:[docker exec roottestbackuprestoreonclustercancelbackup-gw3-node2-1 bash -c ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'] (cluster.py:121, run_and_check) 2025-07-28 10:42:07.566000 [ 653 ] DEBUG : Stdout:10 (cluster.py:145, run_and_check) 2025-07-28 10:42:08.567000 [ 653 ] DEBUG : run container_id:roottestbackuprestoreonclustercancelbackup-gw3-node2-1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:2051, exec_in_container) 2025-07-28 10:42:08.568000 [ 653 ] DEBUG : Command:[docker exec roottestbackuprestoreonclustercancelbackup-gw3-node2-1 bash -c ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'] (cluster.py:121, run_and_check) 2025-07-28 10:42:08.624000 [ 653 ] DEBUG : Stdout:10 (cluster.py:145, run_and_check) 2025-07-28 10:42:09.625000 [ 653 ] DEBUG : run container_id:roottestbackuprestoreonclustercancelbackup-gw3-node2-1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:2051, exec_in_container) 2025-07-28 10:42:09.625000 [ 653 ] DEBUG : Command:[docker exec roottestbackuprestoreonclustercancelbackup-gw3-node2-1 bash -c ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'] (cluster.py:121, run_and_check) 2025-07-28 10:42:09.677000 [ 653 ] DEBUG : Stdout:10 (cluster.py:145, run_and_check) 2025-07-28 10:42:10.680000 [ 653 ] DEBUG : run container_id:roottestbackuprestoreonclustercancelbackup-gw3-node2-1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:2051, exec_in_container) 2025-07-28 10:42:10.680000 [ 653 ] DEBUG : Command:[docker exec roottestbackuprestoreonclustercancelbackup-gw3-node2-1 bash -c ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'] (cluster.py:121, run_and_check) 2025-07-28 10:42:10.730000 [ 653 ] DEBUG : Stdout:10 (cluster.py:145, run_and_check) 2025-07-28 10:42:11.732000 [ 653 ] DEBUG : run container_id:roottestbackuprestoreonclustercancelbackup-gw3-node2-1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:2051, exec_in_container) 2025-07-28 10:42:11.732000 [ 653 ] DEBUG : Command:[docker exec roottestbackuprestoreonclustercancelbackup-gw3-node2-1 bash -c ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'] (cluster.py:121, run_and_check) 2025-07-28 10:42:11.796000 [ 653 ] DEBUG : Stdout:10 (cluster.py:145, run_and_check) 2025-07-28 10:42:12.797000 [ 653 ] DEBUG : run container_id:roottestbackuprestoreonclustercancelbackup-gw3-node2-1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:2051, exec_in_container) 2025-07-28 10:42:12.797000 [ 653 ] DEBUG : Command:[docker exec roottestbackuprestoreonclustercancelbackup-gw3-node2-1 bash -c ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'] (cluster.py:121, run_and_check) 2025-07-28 10:42:12.858000 [ 653 ] DEBUG : run container_id:roottestbackuprestoreonclustercancelbackup-gw3-node2-1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:2051, exec_in_container) 2025-07-28 10:42:12.859000 [ 653 ] DEBUG : Command:[docker exec roottestbackuprestoreonclustercancelbackup-gw3-node2-1 bash -c ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'] (cluster.py:121, run_and_check) 2025-07-28 10:42:12.923000 [ 653 ] DEBUG : No clickhouse process running. Start new one. (cluster.py:4014, start_clickhouse) 2025-07-28 10:42:12.926000 [ 653 ] DEBUG : http://localhost:None "POST /v1.46/containers/roottestbackuprestoreonclustercancelbackup-gw3-node2-1/exec HTTP/1.1" 201 74 (connectionpool.py:547, _make_request) 2025-07-28 10:42:12.962000 [ 653 ] DEBUG : http://localhost:None "POST /v1.46/exec/c4c8414f8e12eb7b0b559dea18854bf1f640ae6487b6ded1b40742839dafcfd2/start HTTP/1.1" 200 0 (connectionpool.py:547, _make_request) 2025-07-28 10:42:12.965000 [ 653 ] DEBUG : http://localhost:None "GET /v1.46/exec/c4c8414f8e12eb7b0b559dea18854bf1f640ae6487b6ded1b40742839dafcfd2/json HTTP/1.1" 200 587 (connectionpool.py:547, _make_request) 2025-07-28 10:42:13.967000 [ 653 ] DEBUG : run container_id:roottestbackuprestoreonclustercancelbackup-gw3-node2-1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:2051, exec_in_container) 2025-07-28 10:42:13.967000 [ 653 ] DEBUG : Command:[docker exec roottestbackuprestoreonclustercancelbackup-gw3-node2-1 bash -c ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'] (cluster.py:121, run_and_check) 2025-07-28 10:42:14.020000 [ 653 ] DEBUG : Stdout:871 (cluster.py:145, run_and_check) 2025-07-28 10:42:14.020000 [ 653 ] DEBUG : Clickhouse process running. (cluster.py:4028, start_clickhouse) 2025-07-28 10:42:14.020000 [ 653 ] DEBUG : run container_id:roottestbackuprestoreonclustercancelbackup-gw3-node2-1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:2051, exec_in_container) 2025-07-28 10:42:14.020000 [ 653 ] DEBUG : Command:[docker exec roottestbackuprestoreonclustercancelbackup-gw3-node2-1 bash -c ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'] (cluster.py:121, run_and_check) 2025-07-28 10:42:14.069000 [ 653 ] DEBUG : Stdout:871 (cluster.py:145, run_and_check) 2025-07-28 10:42:14.069000 [ 653 ] DEBUG : Executing query select 20 on node2 (cluster.py:3648, query) 2025-07-28 10:42:14.135000 [ 653 ] DEBUG : Executing query SELECT count() FROM system.processes WHERE (query_kind='Backup') AND (query LIKE '%7d3121388d33402c8fcdea634dbb5c23%') on node1 (cluster.py:3648, query) 2025-07-28 10:42:14.199000 [ 653 ] DEBUG : Executing query SELECT count() FROM system.processes WHERE (query_kind='Backup') AND (query LIKE '%7d3121388d33402c8fcdea634dbb5c23%') on node2 (cluster.py:3648, query) 2025-07-28 10:42:14.315000 [ 653 ] DEBUG : Executing query SELECT status FROM system.backups WHERE id='7d3121388d33402c8fcdea634dbb5c23' on node1 (cluster.py:3648, query) 2025-07-28 10:42:14.380000 [ 653 ] DEBUG : Executing query SELECT error FROM system.backups WHERE id='7d3121388d33402c8fcdea634dbb5c23' on node1 (cluster.py:3648, query) 2025-07-28 10:42:14.495000 [ 653 ] DEBUG : Executing query SYSTEM FLUSH LOGS on node1 (cluster.py:3648, query) 2025-07-28 10:42:14.662000 [ 653 ] DEBUG : Executing query SELECT status FROM system.backup_log WHERE id='7d3121388d33402c8fcdea634dbb5c23' ORDER BY status on node1 (cluster.py:3648, query) 2025-07-28 10:42:14.728000 [ 653 ] DEBUG : Executing query SELECT name FROM system.zookeeper WHERE path = '/clickhouse/backups' AND NOT (name == 'alive_tracker') on node1 (cluster.py:3648, query) 2025-07-28 10:42:14.843000 [ 653 ] DEBUG : Executing query SELECT name FROM system.errors WHERE last_error_time >= toDateTime('2025-07-28 10:42:02') AND NOT ((name == 'KEEPER_EXCEPTION') AND (last_error_message LIKE '%Fault injection%')) AND NOT (name == 'NO_ELEMENTS_IN_CONFIG') on node1 (cluster.py:3648, query) 2025-07-28 10:42:14.908000 [ 653 ] DEBUG : Executing query SELECT name, last_error_message FROM system.errors WHERE last_error_time >= toDateTime('2025-07-28 10:42:02') on node1 (cluster.py:3648, query) 2025-07-28 10:42:15.023000 [ 653 ] DEBUG : Executing query SELECT name FROM system.errors WHERE last_error_time >= toDateTime('2025-07-28 10:42:02') AND NOT ((name == 'KEEPER_EXCEPTION') AND (last_error_message LIKE '%Fault injection%')) AND NOT (name == 'NO_ELEMENTS_IN_CONFIG') on node2 (cluster.py:3648, query) 2025-07-28 10:42:15.089000 [ 653 ] DEBUG : Executing query SELECT name, last_error_message FROM system.errors WHERE last_error_time >= toDateTime('2025-07-28 10:42:02') on node2 (cluster.py:3648, query) ---------------------------- Captured log teardown ----------------------------- 2025-07-28 10:42:15.235000 [ 653 ] DEBUG : Executing query DROP TABLE IF EXISTS tbl ON CLUSTER 'cluster' SYNC on node1 (cluster.py:3648, query) 2025-07-28 10:42:15.352000 [ 653 ] DEBUG : Command:[docker compose --env-file /ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-cancel_backup-0-gw3/.env --project-name roottestbackuprestoreonclustercancelbackup-gw3 --file /ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-cancel_backup-0-gw3/node1/docker-compose.yml --file /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_keeper.yml --file /ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-cancel_backup-0-gw3/node2/docker-compose.yml stop --timeout 20] (cluster.py:121, run_and_check) 2025-07-28 10:42:17.690000 [ 653 ] DEBUG : Stderr: Container roottestbackuprestoreonclustercancelbackup-gw3-node2-1 Stopping (cluster.py:147, run_and_check) 2025-07-28 10:42:17.691000 [ 653 ] DEBUG : Stderr: Container roottestbackuprestoreonclustercancelbackup-gw3-node1-1 Stopping (cluster.py:147, run_and_check) 2025-07-28 10:42:17.691000 [ 653 ] DEBUG : Stderr: Container roottestbackuprestoreonclustercancelbackup-gw3-node1-1 Stopped (cluster.py:147, run_and_check) 2025-07-28 10:42:17.691000 [ 653 ] DEBUG : Stderr: Container roottestbackuprestoreonclustercancelbackup-gw3-node2-1 Stopped (cluster.py:147, run_and_check) 2025-07-28 10:42:17.691000 [ 653 ] DEBUG : Stderr: Container roottestbackuprestoreonclustercancelbackup-gw3-zoo3-1 Stopping (cluster.py:147, run_and_check) 2025-07-28 10:42:17.691000 [ 653 ] DEBUG : Stderr: Container roottestbackuprestoreonclustercancelbackup-gw3-zoo1-1 Stopping (cluster.py:147, run_and_check) 2025-07-28 10:42:17.691000 [ 653 ] DEBUG : Stderr: Container roottestbackuprestoreonclustercancelbackup-gw3-zoo2-1 Stopping (cluster.py:147, run_and_check) 2025-07-28 10:42:17.692000 [ 653 ] DEBUG : Stderr: Container roottestbackuprestoreonclustercancelbackup-gw3-zoo1-1 Stopped (cluster.py:147, run_and_check) 2025-07-28 10:42:17.692000 [ 653 ] DEBUG : Stderr: Container roottestbackuprestoreonclustercancelbackup-gw3-zoo3-1 Stopped (cluster.py:147, run_and_check) 2025-07-28 10:42:17.692000 [ 653 ] DEBUG : Stderr: Container roottestbackuprestoreonclustercancelbackup-gw3-zoo2-1 Stopped (cluster.py:147, run_and_check) 2025-07-28 10:42:17.692000 [ 653 ] DEBUG : Command:[bash -c [ -f /ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-cancel_backup-0-gw3/node1/logs/stderr.log ] && zgrep -aH "==================" /ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-cancel_backup-0-gw3/node1/logs/stderr.log* | ( [ -z "" ] && cat || grep -v "$" ) || true] (cluster.py:121, run_and_check) 2025-07-28 10:42:17.708000 [ 653 ] DEBUG : Command:[bash -c [ -f /ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-cancel_backup-0-gw3/node2/logs/stderr.log ] && zgrep -aH "==================" /ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-cancel_backup-0-gw3/node2/logs/stderr.log* | ( [ -z "" ] && cat || grep -v "$" ) || true] (cluster.py:121, run_and_check) 2025-07-28 10:42:17.732000 [ 653 ] DEBUG : Command:[docker compose --env-file /ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-cancel_backup-0-gw3/.env --project-name roottestbackuprestoreonclustercancelbackup-gw3 --file /ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-cancel_backup-0-gw3/node1/docker-compose.yml --file /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_keeper.yml --file /ClickHouse/tests/integration/test_backup_restore_on_cluster/_instances-cancel_backup-0-gw3/node2/docker-compose.yml down --volumes] (cluster.py:121, run_and_check) 2025-07-28 10:42:18.403000 [ 653 ] DEBUG : Stderr: Container roottestbackuprestoreonclustercancelbackup-gw3-node1-1 Stopping (cluster.py:147, run_and_check) 2025-07-28 10:42:18.403000 [ 653 ] DEBUG : Stderr: Container roottestbackuprestoreonclustercancelbackup-gw3-node2-1 Stopping (cluster.py:147, run_and_check) 2025-07-28 10:42:18.403000 [ 653 ] DEBUG : Stderr: Container roottestbackuprestoreonclustercancelbackup-gw3-node2-1 Stopped (cluster.py:147, run_and_check) 2025-07-28 10:42:18.403000 [ 653 ] DEBUG : Stderr: Container roottestbackuprestoreonclustercancelbackup-gw3-node2-1 Removing (cluster.py:147, run_and_check) 2025-07-28 10:42:18.403000 [ 653 ] DEBUG : Stderr: Container roottestbackuprestoreonclustercancelbackup-gw3-node1-1 Stopped (cluster.py:147, run_and_check) 2025-07-28 10:42:18.403000 [ 653 ] DEBUG : Stderr: Container roottestbackuprestoreonclustercancelbackup-gw3-node1-1 Removing (cluster.py:147, run_and_check) 2025-07-28 10:42:18.403000 [ 653 ] DEBUG : Stderr: Container roottestbackuprestoreonclustercancelbackup-gw3-node1-1 Removed (cluster.py:147, run_and_check) 2025-07-28 10:42:18.403000 [ 653 ] DEBUG : Stderr: Container roottestbackuprestoreonclustercancelbackup-gw3-node2-1 Removed (cluster.py:147, run_and_check) 2025-07-28 10:42:18.403000 [ 653 ] DEBUG : Stderr: Container roottestbackuprestoreonclustercancelbackup-gw3-zoo3-1 Stopping (cluster.py:147, run_and_check) 2025-07-28 10:42:18.403000 [ 653 ] DEBUG : Stderr: Container roottestbackuprestoreonclustercancelbackup-gw3-zoo1-1 Stopping (cluster.py:147, run_and_check) 2025-07-28 10:42:18.404000 [ 653 ] DEBUG : Stderr: Container roottestbackuprestoreonclustercancelbackup-gw3-zoo2-1 Stopping (cluster.py:147, run_and_check) 2025-07-28 10:42:18.404000 [ 653 ] DEBUG : Stderr: Container roottestbackuprestoreonclustercancelbackup-gw3-zoo3-1 Stopped (cluster.py:147, run_and_check) 2025-07-28 10:42:18.404000 [ 653 ] DEBUG : Stderr: Container roottestbackuprestoreonclustercancelbackup-gw3-zoo3-1 Removing (cluster.py:147, run_and_check) 2025-07-28 10:42:18.404000 [ 653 ] DEBUG : Stderr: Container roottestbackuprestoreonclustercancelbackup-gw3-zoo2-1 Stopped (cluster.py:147, run_and_check) 2025-07-28 10:42:18.404000 [ 653 ] DEBUG : Stderr: Container roottestbackuprestoreonclustercancelbackup-gw3-zoo2-1 Removing (cluster.py:147, run_and_check) 2025-07-28 10:42:18.404000 [ 653 ] DEBUG : Stderr: Container roottestbackuprestoreonclustercancelbackup-gw3-zoo1-1 Stopped (cluster.py:147, run_and_check) 2025-07-28 10:42:18.404000 [ 653 ] DEBUG : Stderr: Container roottestbackuprestoreonclustercancelbackup-gw3-zoo1-1 Removing (cluster.py:147, run_and_check) 2025-07-28 10:42:18.404000 [ 653 ] DEBUG : Stderr: Container roottestbackuprestoreonclustercancelbackup-gw3-zoo1-1 Removed (cluster.py:147, run_and_check) 2025-07-28 10:42:18.404000 [ 653 ] DEBUG : Stderr: Container roottestbackuprestoreonclustercancelbackup-gw3-zoo3-1 Removed (cluster.py:147, run_and_check) 2025-07-28 10:42:18.404000 [ 653 ] DEBUG : Stderr: Container roottestbackuprestoreonclustercancelbackup-gw3-zoo2-1 Removed (cluster.py:147, run_and_check) 2025-07-28 10:42:18.404000 [ 653 ] DEBUG : Stderr: Network roottestbackuprestoreonclustercancelbackup-gw3_default Removing (cluster.py:147, run_and_check) 2025-07-28 10:42:18.404000 [ 653 ] DEBUG : Stderr: Network roottestbackuprestoreonclustercancelbackup-gw3_default Removed (cluster.py:147, run_and_check) 2025-07-28 10:42:18.404000 [ 653 ] DEBUG : Cleanup called (cluster.py:851, cleanup) 2025-07-28 10:42:18.434000 [ 653 ] DEBUG : Docker networks for project roottestbackuprestoreonclustercancelbackup-gw3 are NETWORK ID NAME DRIVER SCOPE (cluster.py:830, print_all_docker_pieces) 2025-07-28 10:42:18.468000 [ 653 ] DEBUG : Docker containers for project roottestbackuprestoreonclustercancelbackup-gw3 are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES (cluster.py:838, print_all_docker_pieces) 2025-07-28 10:42:18.495000 [ 653 ] DEBUG : Docker volumes for project roottestbackuprestoreonclustercancelbackup-gw3 are DRIVER VOLUME NAME (cluster.py:846, print_all_docker_pieces) 2025-07-28 10:42:18.495000 [ 653 ] DEBUG : Command:[docker container list --all --filter name='^/roottestbackuprestoreonclustercancelbackup-gw3-.*-1$' --format '{{.ID}}:{{.Names}}'] (cluster.py:121, run_and_check) 2025-07-28 10:42:18.523000 [ 653 ] DEBUG : Unstopped containers: {} (cluster.py:865, cleanup) 2025-07-28 10:42:18.523000 [ 653 ] DEBUG : No running containers for project: roottestbackuprestoreonclustercancelbackup-gw3 (cluster.py:879, cleanup) 2025-07-28 10:42:18.524000 [ 653 ] DEBUG : Trying to prune unused networks... (cluster.py:885, cleanup) 2025-07-28 10:42:18.550000 [ 653 ] DEBUG : Trying to prune unused images... (cluster.py:901, cleanup) 2025-07-28 10:42:18.550000 [ 653 ] DEBUG : Command:[docker image prune -f] (cluster.py:121, run_and_check) 2025-07-28 10:42:18.598000 [ 653 ] DEBUG : Stdout:Total reclaimed space: 0B (cluster.py:145, run_and_check) 2025-07-28 10:42:18.598000 [ 653 ] DEBUG : Images pruned (cluster.py:904, cleanup) 2025-07-28 10:42:18.599000 [ 653 ] DEBUG : Trying to prune unused volumes... (cluster.py:910, cleanup) 2025-07-28 10:42:18.599000 [ 653 ] DEBUG : Command:[docker volume ls | wc -l] (cluster.py:121, run_and_check) 2025-07-28 10:42:18.617000 [ 653 ] DEBUG : Stdout:1 (cluster.py:145, run_and_check) 2025-07-28 10:42:18.618000 [ 653 ] DEBUG : Volumes pruned: 1 (cluster.py:915, cleanup) ____________________ test_cow_policy[cow_policy_multi_disk] ____________________ [gw2] linux -- Python 3.10.12 /usr/bin/python3 start_cluster = storage_policy = 'cow_policy_multi_disk' @pytest.mark.parametrize("storage_policy", ["cow_policy_multi_disk", "cow_policy_multi_volume"]) def test_cow_policy(start_cluster, storage_policy): try: > node.query_with_retry( f""" ATTACH TABLE uk_price_paid UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7' ( price UInt32, date Date, postcode1 LowCardinality(String), postcode2 LowCardinality(String), type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4), is_new UInt8, duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2), addr1 String, addr2 String, street LowCardinality(String), locality LowCardinality(String), town LowCardinality(String), district LowCardinality(String), county LowCardinality(String) ) ENGINE = MergeTree ORDER BY (postcode1, postcode2, addr1, addr2) SETTINGS storage_policy = '{storage_policy}' """, timeout=60, retry_count=3, ) test_cow_policy/test.py:24: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ self = sql = "\n ATTACH TABLE uk_price_paid UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7'\n (\n ...R BY (postcode1, postcode2, addr1, addr2)\n SETTINGS storage_policy = 'cow_policy_multi_disk'\n " stdin = None, timeout = 60, settings = None, user = None, password = None database = None, host = None, ignore_error = False, retry_count = 3 sleep_time = 0.5 check_callback = at 0x7f3430758d30> parse = False def query_with_retry( self, sql, stdin=None, timeout=None, settings=None, user=None, password=None, database=None, host=None, ignore_error=False, retry_count=20, sleep_time=0.5, check_callback=lambda x: True, parse=False, ): # logging.debug(f"Executing query {sql} on {self.name}") result = None exception_msg = "" for i in range(retry_count): try: result = self.query( sql, stdin=stdin, timeout=timeout, settings=settings, user=user, password=password, database=database, host=host, ignore_error=ignore_error, parse=parse, ) if check_callback(result): return result time.sleep(sleep_time) except QueryRuntimeException as ex: exception_msg = f"{type(ex).__name__}: {str(ex)}" # Container is down, this is likely due to server crash. if "No route to host" in str(ex): raise time.sleep(sleep_time) except Exception as ex: # logging.debug("Retry {} got exception {}".format(i + 1, ex)) exception_msg = f"{type(ex).__name__}: {str(ex)}" time.sleep(sleep_time) if result is not None: return result > raise Exception(f"Can't execute query {sql}\n{exception_msg}") E Exception: Can't execute query E ATTACH TABLE uk_price_paid UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7' E ( E price UInt32, E date Date, E postcode1 LowCardinality(String), E postcode2 LowCardinality(String), E type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4), E is_new UInt8, E duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2), E addr1 String, E addr2 String, E street LowCardinality(String), E locality LowCardinality(String), E town LowCardinality(String), E district LowCardinality(String), E county LowCardinality(String) E ) E ENGINE = MergeTree E ORDER BY (postcode1, postcode2, addr1, addr2) E SETTINGS storage_policy = 'cow_policy_multi_disk' E E QueryRuntimeException: Client failed! Return code: 198, stderr: Received exception from server (version 25.3.6): E Code: 198. DB::Exception: Received from 172.16.9.2:9000. DB::NetException. DB::NetException: Not found address of host: raw.githubusercontent.com: while loading disk metadata. Stack trace: E E 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000f52449b E 1. DB::NetException::NetException(int, FormatStringHelperImpl::type>, String const&) @ 0x000000000f4f92e4 E 2. DB::(anonymous namespace)::hostByName(String const&) @ 0x000000000f4fae24 E 3. DB::DNSResolver::getResolvedIPAdressessWithFiltering(String const&) @ 0x000000000f4f8cd2 E 4. DB::DNSResolver::resolveIPAddressWithCache(String const&) @ 0x000000000f4f9e9a E 5. std::vector> std::__function::__policy_invoker> (String const&)>::__call_impl[abi:ne190107]> (String const&)>>(std::__function::__policy_storage const*, String const&) @ 0x000000000f8b6296 E 6. DB::HostResolver::update() @ 0x000000000f8b12cc E 7. DB::HostResolver::HostResolver(String, Poco::Timespan) @ 0x000000000f8b1169 E 8. std::shared_ptr DB::HostResolver::create(String const&)::make_shared_enabler::make_shared_enabler(String const&) @ 0x000000000f8b680d E 9. std::shared_ptr DB::HostResolver::create(String const&)::make_shared_enabler> std::allocate_shared[abi:ne190107] DB::HostResolver::create(String const&)::make_shared_enabler, std::allocator DB::HostResolver::create(String const&)::make_shared_enabler>, String const&, 0>(std::allocator DB::HostResolver::create(String const&)::make_shared_enabler> const&, String const&) @ 0x000000000f8b6672 E 10. DB::HostResolversPool::getResolver(String const&) @ 0x000000000f8b3173 E 11. DB::EndpointConnectionPool::getConnection(DB::ConnectionTimeouts const&, unsigned long*) @ 0x000000000f8a71d5 E 12. DB::makeHTTPSession(DB::HTTPConnectionGroupType, Poco::URI const&, DB::ConnectionTimeouts const&, DB::ProxyConfiguration const&, unsigned long*) @ 0x000000000f8c0216 E 13. DB::ReadWriteBufferFromHTTP::callImpl(Poco::Net::HTTPResponse&, String const&, std::optional const&, bool) const @ 0x000000001136ca7c E 14. DB::ReadWriteBufferFromHTTP::callWithRedirects(Poco::Net::HTTPResponse&, String const&, std::optional const&) @ 0x000000001136ceba E 15. void std::__function::__policy_invoker::__call_impl[abi:ne190107]>(std::__function::__policy_storage const*) @ 0x00000000113710cc E 16. DB::ReadWriteBufferFromHTTP::doWithRetries(std::function&&, std::function, bool) const @ 0x000000001136a1db E 17. DB::ReadWriteBufferFromHTTP::nextImpl() @ 0x000000001136ed3f E 18. DB::WebObjectStorage::loadFiles(String const&, std::unique_lock const&) const @ 0x0000000012c8fca5 E 19. DB::WebObjectStorage::tryGetFileInfo(String const&) const @ 0x0000000012c938a3 E 20. DB::WebObjectStorage::tryGetFileInfo(String const&) const @ 0x0000000012c93467 E 21. DB::MetadataStorageFromStaticFilesWebServer::getStorageObjectsIfExist(String const&) const @ 0x0000000012c8d49e E 22. DB::DiskObjectStorage::readFileIfExists(String const&, DB::ReadSettings const&, std::optional, std::optional) const @ 0x0000000012c24f30 E 23. DB::MergeTreeData::initializeDirectoriesAndFormatVersion(String const&, bool, String const&, bool) @ 0x000000001463fd06 E 24. DB::StorageMergeTree::StorageMergeTree(DB::StorageID const&, String const&, DB::StorageInMemoryMetadata const&, DB::LoadingStrictnessLevel, std::shared_ptr, String const&, DB::MergeTreeData::MergingParams const&, std::unique_ptr>) @ 0x0000000014a08dc8 E 25. DB::create(DB::StorageFactory::Arguments const&) @ 0x0000000014a0556c E 26. DB::StorageFactory::get(DB::ASTCreateQuery const&, String const&, std::shared_ptr, std::shared_ptr, DB::ColumnsDescription const&, DB::ConstraintsDescription const&, DB::LoadingStrictnessLevel, bool) const @ 0x000000001400d9bb E 27. DB::InterpreterCreateQuery::doCreateTable(DB::ASTCreateQuery&, DB::InterpreterCreateQuery::TableProperties const&, std::unique_ptr>&, DB::LoadingStrictnessLevel) @ 0x00000000135c6800 E 28. DB::InterpreterCreateQuery::createTable(DB::ASTCreateQuery&) @ 0x00000000135bb3a2 E 29. DB::InterpreterCreateQuery::execute() @ 0x00000000135cea18 E 30. DB::executeQueryImpl(char const*, char const*, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum, DB::ReadBuffer*, std::shared_ptr&) @ 0x00000000139f96ab E 31. DB::executeQuery(String const&, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x00000000139f40c4 E . (DNS_ERROR) E (query: ATTACH TABLE uk_price_paid UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7' E ( E price UInt32, E date Date, E postcode1 LowCardinality(String), E postcode2 LowCardinality(String), E type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4), E is_new UInt8, E duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2), E addr1 String, E addr2 String, E street LowCardinality(String), E locality LowCardinality(String), E town LowCardinality(String), E district LowCardinality(String), E county LowCardinality(String) E ) E ENGINE = MergeTree E ORDER BY (postcode1, postcode2, addr1, addr2) E SETTINGS storage_policy = 'cow_policy_multi_disk' E ) helpers/cluster.py:3712: Exception ---------------------------- Captured stdout setup ----------------------------- Copy common default production configuration from /clickhouse-config. Files: config.xml, users.xml ------------------------------ Captured log setup ------------------------------ 2025-07-28 10:40:27.124000 [ 650 ] INFO : Running tests in /ClickHouse/tests/integration/test_cow_policy/test.py (cluster.py:2738, start) 2025-07-28 10:40:27.124000 [ 650 ] DEBUG : Cluster start called. is_up=False (cluster.py:2745, start) 2025-07-28 10:40:27.165000 [ 650 ] DEBUG : Docker networks for project roottestcowpolicy-gw2 are NETWORK ID NAME DRIVER SCOPE (cluster.py:830, print_all_docker_pieces) 2025-07-28 10:40:27.209000 [ 650 ] DEBUG : Docker containers for project roottestcowpolicy-gw2 are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES (cluster.py:838, print_all_docker_pieces) 2025-07-28 10:40:27.236000 [ 650 ] DEBUG : Docker volumes for project roottestcowpolicy-gw2 are DRIVER VOLUME NAME (cluster.py:846, print_all_docker_pieces) 2025-07-28 10:40:27.236000 [ 650 ] DEBUG : Cleanup called (cluster.py:851, cleanup) 2025-07-28 10:40:27.264000 [ 650 ] DEBUG : Docker networks for project roottestcowpolicy-gw2 are NETWORK ID NAME DRIVER SCOPE (cluster.py:830, print_all_docker_pieces) 2025-07-28 10:40:27.285000 [ 650 ] DEBUG : Docker containers for project roottestcowpolicy-gw2 are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES (cluster.py:838, print_all_docker_pieces) 2025-07-28 10:40:27.306000 [ 650 ] DEBUG : Docker volumes for project roottestcowpolicy-gw2 are DRIVER VOLUME NAME (cluster.py:846, print_all_docker_pieces) 2025-07-28 10:40:27.307000 [ 650 ] DEBUG : Command:[docker container list --all --filter name='^/roottestcowpolicy-gw2-.*-1$' --format '{{.ID}}:{{.Names}}'] (cluster.py:121, run_and_check) 2025-07-28 10:40:27.330000 [ 650 ] DEBUG : Unstopped containers: {} (cluster.py:865, cleanup) 2025-07-28 10:40:27.330000 [ 650 ] DEBUG : No running containers for project: roottestcowpolicy-gw2 (cluster.py:879, cleanup) 2025-07-28 10:40:27.330000 [ 650 ] DEBUG : Trying to prune unused networks... (cluster.py:885, cleanup) 2025-07-28 10:40:27.359000 [ 650 ] DEBUG : Trying to prune unused images... (cluster.py:901, cleanup) 2025-07-28 10:40:27.359000 [ 650 ] DEBUG : Command:[docker image prune -f] (cluster.py:121, run_and_check) 2025-07-28 10:40:27.394000 [ 650 ] DEBUG : Stdout:Total reclaimed space: 0B (cluster.py:145, run_and_check) 2025-07-28 10:40:27.394000 [ 650 ] DEBUG : Images pruned (cluster.py:904, cleanup) 2025-07-28 10:40:27.394000 [ 650 ] DEBUG : Trying to prune unused volumes... (cluster.py:910, cleanup) 2025-07-28 10:40:27.394000 [ 650 ] DEBUG : Command:[docker volume ls | wc -l] (cluster.py:121, run_and_check) 2025-07-28 10:40:27.422000 [ 650 ] DEBUG : Stdout:6 (cluster.py:145, run_and_check) 2025-07-28 10:40:27.422000 [ 650 ] DEBUG : Command:[docker volume prune -f] (cluster.py:121, run_and_check) 2025-07-28 10:40:27.446000 [ 650 ] DEBUG : Stdout:Total reclaimed space: 0B (cluster.py:145, run_and_check) 2025-07-28 10:40:27.447000 [ 650 ] DEBUG : Volumes pruned: 6 (cluster.py:915, cleanup) 2025-07-28 10:40:27.447000 [ 650 ] DEBUG : Setup directory for instance: node (cluster.py:2758, start) 2025-07-28 10:40:27.447000 [ 650 ] DEBUG : Create directory for configuration generated in this helper (cluster.py:4628, create_dir) 2025-07-28 10:40:27.448000 [ 650 ] DEBUG : Create directory for common tests configuration (cluster.py:4633, create_dir) 2025-07-28 10:40:27.448000 [ 650 ] DEBUG : Copy common configuration from helpers (cluster.py:4653, create_dir) 2025-07-28 10:40:27.449000 [ 650 ] DEBUG : Generate and write macros file (cluster.py:4705, create_dir) 2025-07-28 10:40:27.449000 [ 650 ] DEBUG : Copy custom test config files ['/ClickHouse/tests/integration/test_cow_policy/configs/overrides.yaml'] to /ClickHouse/tests/integration/test_cow_policy/_instances-0-gw2/node/configs/config.d (cluster.py:4741, create_dir) 2025-07-28 10:40:27.450000 [ 650 ] DEBUG : Setup database dir /ClickHouse/tests/integration/test_cow_policy/_instances-0-gw2/node/database (cluster.py:4758, create_dir) 2025-07-28 10:40:27.451000 [ 650 ] DEBUG : Setup logs dir /ClickHouse/tests/integration/test_cow_policy/_instances-0-gw2/node/logs (cluster.py:4769, create_dir) 2025-07-28 10:40:27.451000 [ 650 ] DEBUG : Entrypoint cmd: ["clickhouse", "server", "--config-file=/etc/clickhouse-server/config.xml", "--log-file=/var/log/clickhouse-server/clickhouse-server.log", "--errorlog-file=/var/log/clickhouse-server/clickhouse-server.err.log", "--"] (cluster.py:4850, create_dir) 2025-07-28 10:40:27.451000 [ 650 ] DEBUG : Env {'ASAN_OPTIONS': 'use_sigaltstack=0', 'TSAN_OPTIONS': 'use_sigaltstack=0', 'CLICKHOUSE_WATCHDOG_ENABLE': '0', 'CLICKHOUSE_NATS_TLS_SECURE': '0', 'LLVM_PROFILE_FILE': '/var/lib/clickhouse/server_%h_%p_%m.profraw'} stored in /ClickHouse/tests/integration/test_cow_policy/_instances-0-gw2/.env (cluster.py:96, _create_env_file) 2025-07-28 10:40:27.452000 [ 650 ] DEBUG : Trying paths: ['/root/.docker/config.json', '/root/.dockercfg'] (config.py:21, find_config_file) 2025-07-28 10:40:27.452000 [ 650 ] DEBUG : No config file found (config.py:28, find_config_file) 2025-07-28 10:40:27.452000 [ 650 ] DEBUG : Trying paths: ['/root/.docker/config.json', '/root/.dockercfg'] (config.py:21, find_config_file) 2025-07-28 10:40:27.452000 [ 650 ] DEBUG : No config file found (config.py:28, find_config_file) 2025-07-28 10:40:27.462000 [ 650 ] DEBUG : http://localhost:None "GET /version HTTP/1.1" 200 826 (connectionpool.py:547, _make_request) 2025-07-28 10:40:27.463000 [ 650 ] DEBUG : Command:[docker compose --env-file /ClickHouse/tests/integration/test_cow_policy/_instances-0-gw2/.env --project-name roottestcowpolicy-gw2 --file /ClickHouse/tests/integration/test_cow_policy/_instances-0-gw2/node/docker-compose.yml pull] (cluster.py:121, run_and_check) 2025-07-28 10:40:36.562000 [ 650 ] DEBUG : Stderr: node Pulling (cluster.py:147, run_and_check) 2025-07-28 10:40:36.562000 [ 650 ] DEBUG : Stderr: node Pulled (cluster.py:147, run_and_check) 2025-07-28 10:40:36.562000 [ 650 ] DEBUG : ('Trying to create ClickHouse instance by command %s', 'docker compose --env-file /ClickHouse/tests/integration/test_cow_policy/_instances-0-gw2/.env --project-name roottestcowpolicy-gw2 --file /ClickHouse/tests/integration/test_cow_policy/_instances-0-gw2/node/docker-compose.yml up -d --no-recreate') (cluster.py:3139, start) 2025-07-28 10:40:36.562000 [ 650 ] DEBUG : Command:[docker compose --env-file /ClickHouse/tests/integration/test_cow_policy/_instances-0-gw2/.env --project-name roottestcowpolicy-gw2 --file /ClickHouse/tests/integration/test_cow_policy/_instances-0-gw2/node/docker-compose.yml up -d --no-recreate] (cluster.py:121, run_and_check) 2025-07-28 10:40:37.466000 [ 650 ] DEBUG : Stderr: Network roottestcowpolicy-gw2_default Creating (cluster.py:147, run_and_check) 2025-07-28 10:40:37.466000 [ 650 ] DEBUG : Stderr: Network roottestcowpolicy-gw2_default Created (cluster.py:147, run_and_check) 2025-07-28 10:40:37.466000 [ 650 ] DEBUG : Stderr: Container roottestcowpolicy-gw2-node-1 Creating (cluster.py:147, run_and_check) 2025-07-28 10:40:37.466000 [ 650 ] DEBUG : Stderr: Container roottestcowpolicy-gw2-node-1 Created (cluster.py:147, run_and_check) 2025-07-28 10:40:37.466000 [ 650 ] DEBUG : Stderr: Container roottestcowpolicy-gw2-node-1 Starting (cluster.py:147, run_and_check) 2025-07-28 10:40:37.467000 [ 650 ] DEBUG : Stderr: Container roottestcowpolicy-gw2-node-1 Started (cluster.py:147, run_and_check) 2025-07-28 10:40:37.467000 [ 650 ] DEBUG : ClickHouse instance created (cluster.py:3147, start) 2025-07-28 10:40:37.467000 [ 650 ] DEBUG : get_instance_ip instance_name=node (cluster.py:2005, get_instance_ip) 2025-07-28 10:40:37.468000 [ 650 ] DEBUG : http://localhost:None "GET /v1.46/containers/roottestcowpolicy-gw2-node-1/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-07-28 10:40:37.469000 [ 650 ] DEBUG : get_instance_ip instance_name=node (cluster.py:2015, get_instance_global_ipv6) 2025-07-28 10:40:37.470000 [ 650 ] DEBUG : http://localhost:None "GET /v1.46/containers/roottestcowpolicy-gw2-node-1/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-07-28 10:40:37.471000 [ 650 ] DEBUG : Waiting for ClickHouse start in node, ip: 172.16.9.2... (cluster.py:3155, start) 2025-07-28 10:40:37.474000 [ 650 ] DEBUG : http://localhost:None "GET /v1.46/containers/roottestcowpolicy-gw2-node-1/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-07-28 10:40:37.475000 [ 650 ] DEBUG : http://localhost:None "GET /v1.46/containers/9d13f23c0411b62534460c3ddcdc06235ff1df90605914d1f8ecbb0feb272a02/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-07-28 10:40:37.578000 [ 650 ] DEBUG : http://localhost:None "GET /v1.46/containers/9d13f23c0411b62534460c3ddcdc06235ff1df90605914d1f8ecbb0feb272a02/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-07-28 10:40:37.685000 [ 650 ] DEBUG : http://localhost:None "GET /v1.46/containers/9d13f23c0411b62534460c3ddcdc06235ff1df90605914d1f8ecbb0feb272a02/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-07-28 10:40:37.787000 [ 650 ] DEBUG : http://localhost:None "GET /v1.46/containers/9d13f23c0411b62534460c3ddcdc06235ff1df90605914d1f8ecbb0feb272a02/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-07-28 10:40:37.891000 [ 650 ] DEBUG : http://localhost:None "GET /v1.46/containers/9d13f23c0411b62534460c3ddcdc06235ff1df90605914d1f8ecbb0feb272a02/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-07-28 10:40:37.993000 [ 650 ] DEBUG : http://localhost:None "GET /v1.46/containers/9d13f23c0411b62534460c3ddcdc06235ff1df90605914d1f8ecbb0feb272a02/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-07-28 10:40:38.096000 [ 650 ] DEBUG : http://localhost:None "GET /v1.46/containers/9d13f23c0411b62534460c3ddcdc06235ff1df90605914d1f8ecbb0feb272a02/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-07-28 10:40:38.097000 [ 650 ] DEBUG : ClickHouse node started (cluster.py:3159, start) ------------------------------ Captured log call ------------------------------- 2025-07-28 10:40:38.099000 [ 650 ] DEBUG : Executing query ATTACH TABLE uk_price_paid UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7' ( price UInt32, date Date, postcode1 LowCardinality(String), postcode2 LowCardinality(String), type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4), is_new UInt8, duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2), addr1 String, addr2 String, street LowCardinality(String), locality LowCardinality(String), town LowCardinality(String), district LowCardinality(String), county LowCardinality(String) ) ENGINE = MergeTree ORDER BY (postcode1, postcode2, addr1, addr2) SETTINGS storage_policy = 'cow_policy_multi_disk' on node (cluster.py:3648, query) 2025-07-28 10:41:31.912000 [ 650 ] DEBUG : Executing query ATTACH TABLE uk_price_paid UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7' ( price UInt32, date Date, postcode1 LowCardinality(String), postcode2 LowCardinality(String), type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4), is_new UInt8, duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2), addr1 String, addr2 String, street LowCardinality(String), locality LowCardinality(String), town LowCardinality(String), district LowCardinality(String), county LowCardinality(String) ) ENGINE = MergeTree ORDER BY (postcode1, postcode2, addr1, addr2) SETTINGS storage_policy = 'cow_policy_multi_disk' on node (cluster.py:3648, query) 2025-07-28 10:42:26.674000 [ 650 ] DEBUG : Executing query ATTACH TABLE uk_price_paid UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7' ( price UInt32, date Date, postcode1 LowCardinality(String), postcode2 LowCardinality(String), type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4), is_new UInt8, duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2), addr1 String, addr2 String, street LowCardinality(String), locality LowCardinality(String), town LowCardinality(String), district LowCardinality(String), county LowCardinality(String) ) ENGINE = MergeTree ORDER BY (postcode1, postcode2, addr1, addr2) SETTINGS storage_policy = 'cow_policy_multi_disk' on node (cluster.py:3648, query) 2025-07-28 10:43:21.690000 [ 650 ] DEBUG : Executing query DROP TABLE IF EXISTS uk_price_paid SYNC on node (cluster.py:3648, query) ___________________ test_cow_policy[cow_policy_multi_volume] ___________________ [gw2] linux -- Python 3.10.12 /usr/bin/python3 start_cluster = storage_policy = 'cow_policy_multi_volume' @pytest.mark.parametrize("storage_policy", ["cow_policy_multi_disk", "cow_policy_multi_volume"]) def test_cow_policy(start_cluster, storage_policy): try: > node.query_with_retry( f""" ATTACH TABLE uk_price_paid UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7' ( price UInt32, date Date, postcode1 LowCardinality(String), postcode2 LowCardinality(String), type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4), is_new UInt8, duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2), addr1 String, addr2 String, street LowCardinality(String), locality LowCardinality(String), town LowCardinality(String), district LowCardinality(String), county LowCardinality(String) ) ENGINE = MergeTree ORDER BY (postcode1, postcode2, addr1, addr2) SETTINGS storage_policy = '{storage_policy}' """, timeout=60, retry_count=3, ) test_cow_policy/test.py:24: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ self = sql = "\n ATTACH TABLE uk_price_paid UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7'\n (\n ...BY (postcode1, postcode2, addr1, addr2)\n SETTINGS storage_policy = 'cow_policy_multi_volume'\n " stdin = None, timeout = 60, settings = None, user = None, password = None database = None, host = None, ignore_error = False, retry_count = 3 sleep_time = 0.5 check_callback = at 0x7f3430758d30> parse = False def query_with_retry( self, sql, stdin=None, timeout=None, settings=None, user=None, password=None, database=None, host=None, ignore_error=False, retry_count=20, sleep_time=0.5, check_callback=lambda x: True, parse=False, ): # logging.debug(f"Executing query {sql} on {self.name}") result = None exception_msg = "" for i in range(retry_count): try: result = self.query( sql, stdin=stdin, timeout=timeout, settings=settings, user=user, password=password, database=database, host=host, ignore_error=ignore_error, parse=parse, ) if check_callback(result): return result time.sleep(sleep_time) except QueryRuntimeException as ex: exception_msg = f"{type(ex).__name__}: {str(ex)}" # Container is down, this is likely due to server crash. if "No route to host" in str(ex): raise time.sleep(sleep_time) except Exception as ex: # logging.debug("Retry {} got exception {}".format(i + 1, ex)) exception_msg = f"{type(ex).__name__}: {str(ex)}" time.sleep(sleep_time) if result is not None: return result > raise Exception(f"Can't execute query {sql}\n{exception_msg}") E Exception: Can't execute query E ATTACH TABLE uk_price_paid UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7' E ( E price UInt32, E date Date, E postcode1 LowCardinality(String), E postcode2 LowCardinality(String), E type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4), E is_new UInt8, E duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2), E addr1 String, E addr2 String, E street LowCardinality(String), E locality LowCardinality(String), E town LowCardinality(String), E district LowCardinality(String), E county LowCardinality(String) E ) E ENGINE = MergeTree E ORDER BY (postcode1, postcode2, addr1, addr2) E SETTINGS storage_policy = 'cow_policy_multi_volume' E E QueryRuntimeException: Client failed! Return code: 198, stderr: Received exception from server (version 25.3.6): E Code: 198. DB::Exception: Received from 172.16.9.2:9000. DB::NetException. DB::NetException: Not found address of host: raw.githubusercontent.com: while loading disk metadata. Stack trace: E E 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000f52449b E 1. DB::NetException::NetException(int, FormatStringHelperImpl::type>, String const&) @ 0x000000000f4f92e4 E 2. DB::(anonymous namespace)::hostByName(String const&) @ 0x000000000f4fae24 E 3. DB::DNSResolver::getResolvedIPAdressessWithFiltering(String const&) @ 0x000000000f4f8cd2 E 4. DB::DNSResolver::resolveIPAddressWithCache(String const&) @ 0x000000000f4f9e9a E 5. std::vector> std::__function::__policy_invoker> (String const&)>::__call_impl[abi:ne190107]> (String const&)>>(std::__function::__policy_storage const*, String const&) @ 0x000000000f8b6296 E 6. DB::HostResolver::update() @ 0x000000000f8b12cc E 7. DB::HostResolver::HostResolver(String, Poco::Timespan) @ 0x000000000f8b1169 E 8. std::shared_ptr DB::HostResolver::create(String const&)::make_shared_enabler::make_shared_enabler(String const&) @ 0x000000000f8b680d E 9. std::shared_ptr DB::HostResolver::create(String const&)::make_shared_enabler> std::allocate_shared[abi:ne190107] DB::HostResolver::create(String const&)::make_shared_enabler, std::allocator DB::HostResolver::create(String const&)::make_shared_enabler>, String const&, 0>(std::allocator DB::HostResolver::create(String const&)::make_shared_enabler> const&, String const&) @ 0x000000000f8b6672 E 10. DB::HostResolversPool::getResolver(String const&) @ 0x000000000f8b3173 E 11. DB::EndpointConnectionPool::getConnection(DB::ConnectionTimeouts const&, unsigned long*) @ 0x000000000f8a71d5 E 12. DB::makeHTTPSession(DB::HTTPConnectionGroupType, Poco::URI const&, DB::ConnectionTimeouts const&, DB::ProxyConfiguration const&, unsigned long*) @ 0x000000000f8c0216 E 13. DB::ReadWriteBufferFromHTTP::callImpl(Poco::Net::HTTPResponse&, String const&, std::optional const&, bool) const @ 0x000000001136ca7c E 14. DB::ReadWriteBufferFromHTTP::callWithRedirects(Poco::Net::HTTPResponse&, String const&, std::optional const&) @ 0x000000001136ceba E 15. void std::__function::__policy_invoker::__call_impl[abi:ne190107]>(std::__function::__policy_storage const*) @ 0x00000000113710cc E 16. DB::ReadWriteBufferFromHTTP::doWithRetries(std::function&&, std::function, bool) const @ 0x000000001136a1db E 17. DB::ReadWriteBufferFromHTTP::nextImpl() @ 0x000000001136ed3f E 18. DB::WebObjectStorage::loadFiles(String const&, std::unique_lock const&) const @ 0x0000000012c8fca5 E 19. DB::WebObjectStorage::tryGetFileInfo(String const&) const @ 0x0000000012c938a3 E 20. DB::WebObjectStorage::tryGetFileInfo(String const&) const @ 0x0000000012c93467 E 21. DB::MetadataStorageFromStaticFilesWebServer::getStorageObjectsIfExist(String const&) const @ 0x0000000012c8d49e E 22. DB::DiskObjectStorage::readFileIfExists(String const&, DB::ReadSettings const&, std::optional, std::optional) const @ 0x0000000012c24f30 E 23. DB::MergeTreeData::initializeDirectoriesAndFormatVersion(String const&, bool, String const&, bool) @ 0x000000001463fd06 E 24. DB::StorageMergeTree::StorageMergeTree(DB::StorageID const&, String const&, DB::StorageInMemoryMetadata const&, DB::LoadingStrictnessLevel, std::shared_ptr, String const&, DB::MergeTreeData::MergingParams const&, std::unique_ptr>) @ 0x0000000014a08dc8 E 25. DB::create(DB::StorageFactory::Arguments const&) @ 0x0000000014a0556c E 26. DB::StorageFactory::get(DB::ASTCreateQuery const&, String const&, std::shared_ptr, std::shared_ptr, DB::ColumnsDescription const&, DB::ConstraintsDescription const&, DB::LoadingStrictnessLevel, bool) const @ 0x000000001400d9bb E 27. DB::InterpreterCreateQuery::doCreateTable(DB::ASTCreateQuery&, DB::InterpreterCreateQuery::TableProperties const&, std::unique_ptr>&, DB::LoadingStrictnessLevel) @ 0x00000000135c6800 E 28. DB::InterpreterCreateQuery::createTable(DB::ASTCreateQuery&) @ 0x00000000135bb3a2 E 29. DB::InterpreterCreateQuery::execute() @ 0x00000000135cea18 E 30. DB::executeQueryImpl(char const*, char const*, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum, DB::ReadBuffer*, std::shared_ptr&) @ 0x00000000139f96ab E 31. DB::executeQuery(String const&, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x00000000139f40c4 E . (DNS_ERROR) E (query: ATTACH TABLE uk_price_paid UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7' E ( E price UInt32, E date Date, E postcode1 LowCardinality(String), E postcode2 LowCardinality(String), E type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4), E is_new UInt8, E duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2), E addr1 String, E addr2 String, E street LowCardinality(String), E locality LowCardinality(String), E town LowCardinality(String), E district LowCardinality(String), E county LowCardinality(String) E ) E ENGINE = MergeTree E ORDER BY (postcode1, postcode2, addr1, addr2) E SETTINGS storage_policy = 'cow_policy_multi_volume' E ) helpers/cluster.py:3712: Exception ------------------------------ Captured log call ------------------------------- 2025-07-28 10:43:22.009000 [ 650 ] DEBUG : Executing query ATTACH TABLE uk_price_paid UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7' ( price UInt32, date Date, postcode1 LowCardinality(String), postcode2 LowCardinality(String), type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4), is_new UInt8, duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2), addr1 String, addr2 String, street LowCardinality(String), locality LowCardinality(String), town LowCardinality(String), district LowCardinality(String), county LowCardinality(String) ) ENGINE = MergeTree ORDER BY (postcode1, postcode2, addr1, addr2) SETTINGS storage_policy = 'cow_policy_multi_volume' on node (cluster.py:3648, query) 2025-07-28 10:44:16.904000 [ 650 ] DEBUG : Executing query ATTACH TABLE uk_price_paid UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7' ( price UInt32, date Date, postcode1 LowCardinality(String), postcode2 LowCardinality(String), type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4), is_new UInt8, duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2), addr1 String, addr2 String, street LowCardinality(String), locality LowCardinality(String), town LowCardinality(String), district LowCardinality(String), county LowCardinality(String) ) ENGINE = MergeTree ORDER BY (postcode1, postcode2, addr1, addr2) SETTINGS storage_policy = 'cow_policy_multi_volume' on node (cluster.py:3648, query) 2025-07-28 10:45:13.813000 [ 650 ] DEBUG : Executing query ATTACH TABLE uk_price_paid UUID 'cf712b4f-2ca8-435c-ac23-c4393efe52f7' ( price UInt32, date Date, postcode1 LowCardinality(String), postcode2 LowCardinality(String), type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4), is_new UInt8, duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2), addr1 String, addr2 String, street LowCardinality(String), locality LowCardinality(String), town LowCardinality(String), district LowCardinality(String), county LowCardinality(String) ) ENGINE = MergeTree ORDER BY (postcode1, postcode2, addr1, addr2) SETTINGS storage_policy = 'cow_policy_multi_volume' on node (cluster.py:3648, query) 2025-07-28 10:46:11.427000 [ 650 ] DEBUG : Executing query DROP TABLE IF EXISTS uk_price_paid SYNC on node (cluster.py:3648, query) ---------------------------- Captured log teardown ----------------------------- 2025-07-28 10:46:11.640000 [ 650 ] DEBUG : Command:[docker compose --env-file /ClickHouse/tests/integration/test_cow_policy/_instances-0-gw2/.env --project-name roottestcowpolicy-gw2 --file /ClickHouse/tests/integration/test_cow_policy/_instances-0-gw2/node/docker-compose.yml stop --timeout 20] (cluster.py:121, run_and_check) 2025-07-28 10:46:17.909000 [ 650 ] DEBUG : Stderr: Container roottestcowpolicy-gw2-node-1 Stopping (cluster.py:147, run_and_check) 2025-07-28 10:46:17.909000 [ 650 ] DEBUG : Stderr: Container roottestcowpolicy-gw2-node-1 Stopped (cluster.py:147, run_and_check) 2025-07-28 10:46:17.909000 [ 650 ] DEBUG : Command:[bash -c [ -f /ClickHouse/tests/integration/test_cow_policy/_instances-0-gw2/node/logs/stderr.log ] && zgrep -aH "==================" /ClickHouse/tests/integration/test_cow_policy/_instances-0-gw2/node/logs/stderr.log* | ( [ -z "" ] && cat || grep -v "$" ) || true] (cluster.py:121, run_and_check) 2025-07-28 10:46:17.924000 [ 650 ] DEBUG : Command:[docker compose --env-file /ClickHouse/tests/integration/test_cow_policy/_instances-0-gw2/.env --project-name roottestcowpolicy-gw2 --file /ClickHouse/tests/integration/test_cow_policy/_instances-0-gw2/node/docker-compose.yml down --volumes] (cluster.py:121, run_and_check) 2025-07-28 10:46:18.423000 [ 650 ] DEBUG : Stderr: Container roottestcowpolicy-gw2-node-1 Stopping (cluster.py:147, run_and_check) 2025-07-28 10:46:18.423000 [ 650 ] DEBUG : Stderr: Container roottestcowpolicy-gw2-node-1 Stopped (cluster.py:147, run_and_check) 2025-07-28 10:46:18.423000 [ 650 ] DEBUG : Stderr: Container roottestcowpolicy-gw2-node-1 Removing (cluster.py:147, run_and_check) 2025-07-28 10:46:18.423000 [ 650 ] DEBUG : Stderr: Container roottestcowpolicy-gw2-node-1 Removed (cluster.py:147, run_and_check) 2025-07-28 10:46:18.423000 [ 650 ] DEBUG : Stderr: Network roottestcowpolicy-gw2_default Removing (cluster.py:147, run_and_check) 2025-07-28 10:46:18.423000 [ 650 ] DEBUG : Stderr: Network roottestcowpolicy-gw2_default Removed (cluster.py:147, run_and_check) 2025-07-28 10:46:18.424000 [ 650 ] DEBUG : Cleanup called (cluster.py:851, cleanup) 2025-07-28 10:46:18.451000 [ 650 ] DEBUG : Docker networks for project roottestcowpolicy-gw2 are NETWORK ID NAME DRIVER SCOPE (cluster.py:830, print_all_docker_pieces) 2025-07-28 10:46:18.479000 [ 650 ] DEBUG : Docker containers for project roottestcowpolicy-gw2 are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES (cluster.py:838, print_all_docker_pieces) 2025-07-28 10:46:18.509000 [ 650 ] DEBUG : Docker volumes for project roottestcowpolicy-gw2 are DRIVER VOLUME NAME (cluster.py:846, print_all_docker_pieces) 2025-07-28 10:46:18.509000 [ 650 ] DEBUG : Command:[docker container list --all --filter name='^/roottestcowpolicy-gw2-.*-1$' --format '{{.ID}}:{{.Names}}'] (cluster.py:121, run_and_check) 2025-07-28 10:46:18.537000 [ 650 ] DEBUG : Unstopped containers: {} (cluster.py:865, cleanup) 2025-07-28 10:46:18.537000 [ 650 ] DEBUG : No running containers for project: roottestcowpolicy-gw2 (cluster.py:879, cleanup) 2025-07-28 10:46:18.537000 [ 650 ] DEBUG : Trying to prune unused networks... (cluster.py:885, cleanup) 2025-07-28 10:46:18.565000 [ 650 ] DEBUG : Trying to prune unused images... (cluster.py:901, cleanup) 2025-07-28 10:46:18.565000 [ 650 ] DEBUG : Command:[docker image prune -f] (cluster.py:121, run_and_check) 2025-07-28 10:46:18.601000 [ 650 ] DEBUG : Stdout:Total reclaimed space: 0B (cluster.py:145, run_and_check) 2025-07-28 10:46:18.601000 [ 650 ] DEBUG : Images pruned (cluster.py:904, cleanup) 2025-07-28 10:46:18.601000 [ 650 ] DEBUG : Trying to prune unused volumes... (cluster.py:910, cleanup) 2025-07-28 10:46:18.602000 [ 650 ] DEBUG : Command:[docker volume ls | wc -l] (cluster.py:121, run_and_check) 2025-07-28 10:46:18.630000 [ 650 ] DEBUG : Stdout:1 (cluster.py:145, run_and_check) 2025-07-28 10:46:18.630000 [ 650 ] DEBUG : Volumes pruned: 1 (cluster.py:915, cleanup) ----------------- generated report log file: parallel0_0.jsonl ----------------- ============================== slowest durations =============================== 169.53s call test_cow_policy/test.py::test_cow_policy[cow_policy_multi_volume] 163.66s call test_cow_policy/test.py::test_cow_policy[cow_policy_multi_disk] 91.87s call test_backward_compatibility/test_convert_ordinary.py::test_convert_ordinary_to_atomic 73.94s call test_concurrent_ttl_merges/test.py::test_limited_ttl_merges_in_empty_pool_replicated 73.78s call test_concurrent_ttl_merges/test.py::test_limited_ttl_merges_two_replicas 66.21s call test_ddl_worker_replicas/test.py::test_ddl_worker_replicas 42.70s call test_cluster_discovery/test_auxiliary_keeper.py::test_cluster_discovery_with_auxiliary_keeper_startup_and_stop 40.17s call test_alter_moving_garbage/test.py::test_delete_race_leftovers 39.98s call test_backup_restore_new/test_shutdown_wait_backup.py::test_shutdown_wait_backup 34.49s call test_backup_restore_on_cluster/test_cancel_backup.py::test_cancel_restore 24.80s setup test_dictionaries_mysql/test.py::test_background_dictionary_reconnect 24.31s setup test_check_table_name_length/test.py::test_backward_compatibility 23.38s setup test_distributed_inter_server_secret/test.py::test_insecure 23.19s teardown test_ddl_alter_query/test.py::test_ddl_queue_hostname_change 23.04s teardown test_disk_types/test.py::test_select_by_type 22.09s teardown test_attach_backup_from_s3_plain/test.py::test_attach_part[wide1] 21.95s teardown test_alter_moving_garbage/test.py::test_delete_race_leftovers 21.03s setup test_alter_moving_garbage/test.py::test_alter_moving[False-False] 20.99s call test_backup_restore_on_cluster/test_cancel_backup.py::test_long_disconnection_stops_backup 19.00s setup test_ddl_worker_replicas/test.py::test_ddl_worker_replicas 18.81s setup test_concurrent_ttl_merges/test.py::test_limited_ttl_merges_in_empty_pool 18.52s setup test_backup_restore_on_cluster/test_cancel_backup.py::test_cancel_backup 18.32s setup test_allowed_client_hosts/test.py::test_allowed_host 18.20s call test_dictionaries_all_layouts_separate_sources/test_http.py::test_simple[direct] 17.67s setup test_ddl_alter_query/test.py::test_alter 17.35s setup test_cluster_discovery/test_auxiliary_keeper.py::test_cluster_discovery_with_auxiliary_keeper_startup_and_stop 17.23s setup test_backward_compatibility/test_aggregate_fixed_key.py::test_two_level_merge 17.15s call test_config_yaml_merge_keys/test.py::test_yaml_merge_keys_conf 16.63s setup test_compatibility_merge_tree_settings/test.py::test_check_projections_compatibility 15.64s setup test_dictionaries_all_layouts_separate_sources/test_http.py::test_complex[complex_key_cache] 15.53s call test_backup_restore_on_cluster/test_cancel_backup.py::test_short_disconnection_doesnt_stop_backup 15.38s setup test_attach_backup_from_s3_plain/test.py::test_attach_part[compact0] 15.36s call test_dictionaries_all_layouts_separate_sources/test_executable_cache.py::test_simple[cache] 14.93s setup test_dictionaries_select_all/test.py::test_select_all[clickhouse_complex_integers_key_hashed] 14.58s call test_dictionaries_all_layouts_separate_sources/test_http.py::test_complex[complex_key_direct] 14.53s setup test_disk_types/test.py::test_different_types 14.50s call test_backup_restore_on_cluster/test_cancel_backup.py::test_short_disconnection_doesnt_stop_restore 14.45s call test_dictionaries_all_layouts_separate_sources/test_http.py::test_simple[flat] 14.33s call test_dictionaries_all_layouts_separate_sources/test_http.py::test_complex[complex_key_cache] 14.30s setup test_default_role/test.py::test_alter_user 14.27s call test_dictionaries_all_layouts_separate_sources/test_http.py::test_simple[cache] 14.13s teardown test_distributed_inter_server_secret/test.py::test_secure_cluster_distributed_over_distributed_different_users_cluster 14.11s call test_dictionaries_all_layouts_separate_sources/test_executable_cache.py::test_complex[complex_key_cache] 13.99s call test_backup_restore_on_cluster/test_cancel_backup.py::test_shutdown_cancels_backup 13.56s call test_dictionaries_all_layouts_separate_sources/test_http.py::test_complex[complex_key_hashed] 12.96s setup test_dictionaries_all_layouts_separate_sources/test_executable_cache.py::test_complex[complex_key_cache] 12.72s call test_dictionaries_mysql/test.py::test_background_dictionary_reconnect 12.71s call test_dictionaries_all_layouts_separate_sources/test_http.py::test_simple[hashed] 12.67s setup test_backward_compatibility/test_cte_distributed.py::test_cte_distributed 12.53s setup test_concurrent_queries_for_user_restriction/test.py::test_exception_message 12.43s call test_config_xml_main/test.py::test_xml_main_conf 12.21s setup test_config_reloader_interval/test.py::test_reload_config 12.02s setup test_backward_compatibility/test_memory_bound_aggregation.py::test_backward_compatability 11.88s setup test_backward_compatibility/test_ip_types_binary_compatibility.py::test_ip_types_binary_compatibility 11.22s setup test_backward_compatibility/test_convert_ordinary.py::test_convert_ordinary_to_atomic 11.21s setup test_cleanup_after_start/test.py::test_old_dirs_cleanup 10.98s setup test_cow_policy/test.py::test_cow_policy[cow_policy_multi_disk] 10.95s call test_concurrent_ttl_merges/test.py::test_limited_ttl_merges_in_empty_pool 9.70s setup test_custom_settings/test.py::test_custom_settings 9.55s setup test_compression_nested_columns/test.py::test_nested_compression_codec 9.14s setup test_buffer_profile/test.py::test_buffer_profile 8.93s call test_concurrent_ttl_merges/test.py::test_no_ttl_merges_in_busy_pool 8.45s call test_alter_moving_garbage/test.py::test_alter_moving[True-True] 7.35s call test_alter_moving_garbage/test.py::test_alter_moving[False-False] 6.99s teardown test_cow_policy/test.py::test_cow_policy[cow_policy_multi_volume] 6.92s call test_backup_restore_on_cluster/test_cancel_backup.py::test_cancel_backup 6.69s setup test_cluster_discovery/test_password.py::test_connect_with_password 6.41s call test_backup_log/test.py::test_backup_log 6.39s call test_alter_moving_garbage/test.py::test_alter_moving[False-True] 6.35s call test_dictionaries_all_layouts_separate_sources/test_http.py::test_ranged[range_hashed] 6.18s setup test_backup_restore_new/test_shutdown_wait_backup.py::test_shutdown_wait_backup 5.91s teardown test_compression_nested_columns/test.py::test_nested_compression_codec 5.45s setup test_backward_compatibility/test_short_strings_aggregation.py::test_backward_compatability 5.38s teardown test_backward_compatibility/test_aggregate_fixed_key.py::test_two_level_merge 5.25s teardown test_check_table_name_length/test.py::test_check_table_name_length 5.10s call test_ddl_alter_query/test.py::test_ddl_queue_hostname_change 5.09s teardown test_dictionaries_all_layouts_separate_sources/test_executable_cache.py::test_simple[cache] 4.97s teardown test_concurrent_queries_for_user_restriction/test.py::test_exception_message 4.83s teardown test_ddl_worker_replicas/test.py::test_ddl_worker_replicas 4.82s teardown test_allowed_client_hosts/test.py::test_denied_host 4.76s call test_backup_restore_on_cluster/test_cancel_backup.py::test_error_leaves_no_trash 4.74s teardown test_dictionaries_mysql/test.py::test_predefined_connection_configuration 4.72s teardown test_compatibility_merge_tree_settings/test.py::test_config_overrides_compatibility 4.70s teardown test_concurrent_ttl_merges/test.py::test_no_ttl_merges_in_busy_pool 4.57s teardown test_dictionaries_all_layouts_separate_sources/test_http.py::test_simple[hashed] 4.56s teardown test_custom_settings/test.py::test_illformed_setting 4.56s call test_cleanup_after_start/test.py::test_old_dirs_cleanup 4.50s call test_backward_compatibility/test_ip_types_binary_compatibility.py::test_ip_types_binary_compatibility 4.49s teardown test_default_role/test.py::test_wrong_set_default_role 4.21s call test_distributed_inter_server_secret/test.py::test_insecure_insert_async 4.00s teardown test_backward_compatibility/test_cte_distributed.py::test_cte_distributed 3.97s teardown test_buffer_profile/test.py::test_default_profile 3.66s teardown test_backward_compatibility/test_memory_bound_aggregation.py::test_backward_compatability 3.53s teardown test_backward_compatibility/test_short_strings_aggregation.py::test_backward_compatability 3.45s teardown test_cleanup_after_start/test.py::test_old_dirs_cleanup 3.40s teardown test_dictionaries_select_all/test.py::test_select_all_from_cached[clickhouse_complex_mixed_key_cache] 3.38s teardown test_backup_restore_on_cluster/test_cancel_backup.py::test_shutdown_cancels_backup 3.37s teardown test_cluster_discovery/test_auxiliary_keeper.py::test_cluster_discovery_with_auxiliary_keeper_startup_and_stop 3.29s setup test_backup_log/test.py::test_backup_log 3.16s teardown test_config_reloader_interval/test.py::test_reload_config 2.72s call test_cluster_discovery/test_password.py::test_connect_with_password 2.57s call test_distributed_inter_server_secret/test.py::test_insecure_insert_sync 2.56s teardown test_cluster_discovery/test_password.py::test_connect_with_password 2.54s teardown test_backward_compatibility/test_convert_ordinary.py::test_convert_ordinary_to_atomic 2.07s teardown test_backward_compatibility/test_ip_types_binary_compatibility.py::test_ip_types_binary_compatibility 1.74s teardown test_backup_restore_new/test_shutdown_wait_backup.py::test_shutdown_wait_backup 1.64s call test_compression_nested_columns/test.py::test_nested_compression_codec 1.61s call test_dictionaries_mysql/test.py::test_predefined_connection_configuration 1.51s call test_ddl_alter_query/test.py::test_alter 1.46s call test_backward_compatibility/test_memory_bound_aggregation.py::test_backward_compatability 1.44s call test_dictionaries_select_all/test.py::test_select_all_from_cached[clickhouse_complex_integers_key_cache] 1.41s teardown test_backup_log/test.py::test_backup_log 1.38s call test_compatibility_merge_tree_settings/test.py::test_check_projections_compatibility 1.28s call test_default_role/test.py::test_alter_user 1.18s call test_config_reloader_interval/test.py::test_reload_config 1.14s call test_concurrent_queries_for_user_restriction/test.py::test_exception_message 1.13s call test_dictionaries_select_all/test.py::test_select_all_from_cached[clickhouse_complex_mixed_key_cache] 1.10s call test_default_role/test.py::test_set_default_roles 0.92s call test_dictionaries_select_all/test.py::test_select_all_from_cached[clickhouse_cache] 0.91s call test_dictionaries_mysql/test.py::test_mysql_dictionaries_custom_query_full_load 0.91s call test_backward_compatibility/test_short_strings_aggregation.py::test_backward_compatability 0.89s call test_allowed_client_hosts/test.py::test_allowed_host 0.75s call test_backward_compatibility/test_aggregate_fixed_key.py::test_two_level_merge 0.73s call test_custom_settings/test.py::test_custom_settings 0.70s call test_attach_backup_from_s3_plain/test.py::test_attach_part[compact0] 0.65s call test_distributed_inter_server_secret/test.py::test_secure_cluster_distributed_over_distributed_different_users_cluster 0.47s teardown test_backup_restore_on_cluster/test_cancel_backup.py::test_short_disconnection_doesnt_stop_backup 0.45s call test_attach_backup_from_s3_plain/test.py::test_attach_part[wide0] 0.43s call test_allowed_client_hosts/test.py::test_denied_host 0.40s call test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_secure_cluster[default-] 0.38s call test_dictionaries_mysql/test.py::test_mysql_dictionaries_custom_query_partial_load_complex_key 0.36s call test_check_table_name_length/test.py::test_backward_compatibility 0.36s call test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_insecure_cluster[pass-foo] 0.35s call test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_insecure_cluster[default-] 0.35s call test_attach_backup_from_s3_plain/test.py::test_attach_part[compact1] 0.35s call test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_insecure_cluster[default-] 0.33s call test_default_role/test.py::test_wrong_set_default_role 0.33s call test_dictionaries_mysql/test.py::test_mysql_dictionaries_custom_query_partial_load_simple_key 0.32s call test_check_table_name_length/test.py::test_check_table_name_length 0.30s call test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_secure_cluster[pass-foo] 0.30s call test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_insecure_cluster[nopass-] 0.30s call test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_insecure_cluster[nopass-] 0.30s call test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_insecure_cluster[pass-foo] 0.28s call test_backward_compatibility/test_cte_distributed.py::test_cte_distributed 0.25s call test_disk_types/test.py::test_select_by_type 0.25s call test_dictionaries_select_all/test.py::test_select_all[clickhouse_hashed] 0.25s call test_dictionaries_select_all/test.py::test_select_all[clickhouse_complex_integers_key_hashed] 0.25s call test_dictionaries_select_all/test.py::test_select_all[clickhouse_range_hashed] 0.25s call test_attach_backup_from_s3_plain/test.py::test_attach_part[wide1] 0.25s call test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_secure_cluster[default-] 0.25s call test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_secure_cluster[pass-foo] 0.25s call test_dictionaries_select_all/test.py::test_select_all[clickhouse_flat] 0.24s call test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_secure_cluster[nopass-] 0.22s teardown test_backup_restore_on_cluster/test_cancel_backup.py::test_long_disconnection_stops_backup 0.20s call test_dictionaries_select_all/test.py::test_select_all[clickhouse_complex_mixed_key_hashed] 0.20s call test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_secure_cluster[nopass-] 0.19s call test_custom_settings/test.py::test_illformed_setting 0.18s call test_buffer_profile/test.py::test_buffer_profile 0.18s call test_buffer_profile/test.py::test_default_profile 0.17s teardown test_backup_restore_on_cluster/test_cancel_backup.py::test_cancel_backup 0.17s call test_distributed_inter_server_secret/test.py::test_insecure 0.17s teardown test_backup_restore_on_cluster/test_cancel_backup.py::test_cancel_restore 0.17s teardown test_backup_restore_on_cluster/test_cancel_backup.py::test_error_leaves_no_trash 0.17s teardown test_backup_restore_on_cluster/test_cancel_backup.py::test_short_disconnection_doesnt_stop_restore 0.13s call test_compatibility_merge_tree_settings/test.py::test_config_overrides_compatibility 0.12s call test_distributed_inter_server_secret/test.py::test_secure 0.12s call test_disk_types/test.py::test_different_types 0.07s setup test_default_role/test.py::test_wrong_set_default_role 0.06s setup test_disks_app_interactive/test.py::test_disks_app_interactive_cp_and_read 0.06s call test_disks_app_interactive/test.py::test_disks_app_interactive_list_directories_default 0.05s setup test_default_role/test.py::test_set_default_roles 0.05s call test_disks_app_interactive/test.py::test_disks_app_interactive_cp_and_read 0.03s call test_disks_app_interactive/test.py::test_disks_app_interactive_test_move_and_write 0.03s call test_disks_app_interactive/test.py::test_disks_app_interactive_list_files_local 0.03s call test_disks_app_interactive/test.py::test_disks_app_interactive_list_disks 0.00s setup test_backup_restore_on_cluster/test_cancel_backup.py::test_short_disconnection_doesnt_stop_backup 0.00s setup test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_insecure_cluster[nopass-] 0.00s setup test_config_xml_main/test.py::test_xml_main_conf 0.00s setup test_dictionaries_select_all/test.py::test_select_all[clickhouse_hashed] 0.00s setup test_backup_restore_on_cluster/test_cancel_backup.py::test_shutdown_cancels_backup 0.00s setup test_dictionaries_mysql/test.py::test_predefined_connection_configuration 0.00s teardown test_config_yaml_merge_keys/test.py::test_yaml_merge_keys_conf 0.00s setup test_dictionaries_select_all/test.py::test_select_all[clickhouse_complex_mixed_key_hashed] 0.00s setup test_dictionaries_select_all/test.py::test_select_all_from_cached[clickhouse_cache] 0.00s teardown test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_insecure_cluster[pass-foo] 0.00s teardown test_dictionaries_all_layouts_separate_sources/test_http.py::test_complex[complex_key_direct] 0.00s teardown test_config_xml_main/test.py::test_xml_main_conf 0.00s setup test_attach_backup_from_s3_plain/test.py::test_attach_part[wide0] 0.00s teardown test_allowed_client_hosts/test.py::test_allowed_host 0.00s setup test_dictionaries_all_layouts_separate_sources/test_http.py::test_simple[direct] 0.00s teardown test_concurrent_ttl_merges/test.py::test_limited_ttl_merges_two_replicas 0.00s teardown test_dictionaries_all_layouts_separate_sources/test_http.py::test_complex[complex_key_cache] 0.00s setup test_attach_backup_from_s3_plain/test.py::test_attach_part[compact1] 0.00s setup test_config_yaml_merge_keys/test.py::test_yaml_merge_keys_conf 0.00s setup test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_insecure_cluster[default-] 0.00s teardown test_ddl_alter_query/test.py::test_alter 0.00s setup test_allowed_client_hosts/test.py::test_denied_host 0.00s teardown test_concurrent_ttl_merges/test.py::test_limited_ttl_merges_in_empty_pool 0.00s setup test_attach_backup_from_s3_plain/test.py::test_attach_part[wide1] 0.00s setup test_compatibility_merge_tree_settings/test.py::test_config_overrides_compatibility 0.00s setup test_dictionaries_all_layouts_separate_sources/test_http.py::test_ranged[range_hashed] 0.00s teardown test_distributed_inter_server_secret/test.py::test_insecure 0.00s setup test_backup_restore_on_cluster/test_cancel_backup.py::test_error_leaves_no_trash 0.00s setup test_distributed_inter_server_secret/test.py::test_insecure_insert_async 0.00s teardown test_alter_moving_garbage/test.py::test_alter_moving[False-False] 0.00s teardown test_dictionaries_select_all/test.py::test_select_all[clickhouse_complex_integers_key_hashed] 0.00s setup test_backup_restore_on_cluster/test_cancel_backup.py::test_cancel_restore 0.00s setup test_ddl_alter_query/test.py::test_ddl_queue_hostname_change 0.00s teardown test_dictionaries_select_all/test.py::test_select_all[clickhouse_hashed] 0.00s setup test_backup_restore_on_cluster/test_cancel_backup.py::test_short_disconnection_doesnt_stop_restore 0.00s teardown test_check_table_name_length/test.py::test_backward_compatibility 0.00s setup test_distributed_inter_server_secret/test.py::test_secure 0.00s setup test_dictionaries_select_all/test.py::test_select_all_from_cached[clickhouse_complex_integers_key_cache] 0.00s teardown test_attach_backup_from_s3_plain/test.py::test_attach_part[compact0] 0.00s teardown test_dictionaries_select_all/test.py::test_select_all[clickhouse_range_hashed] 0.00s setup test_dictionaries_mysql/test.py::test_mysql_dictionaries_custom_query_partial_load_complex_key 0.00s teardown test_concurrent_ttl_merges/test.py::test_limited_ttl_merges_in_empty_pool_replicated 0.00s setup test_dictionaries_all_layouts_separate_sources/test_http.py::test_complex[complex_key_hashed] 0.00s setup test_concurrent_ttl_merges/test.py::test_no_ttl_merges_in_busy_pool 0.00s setup test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_secure_cluster[default-] 0.00s setup test_dictionaries_all_layouts_separate_sources/test_http.py::test_complex[complex_key_direct] 0.00s setup test_dictionaries_select_all/test.py::test_select_all_from_cached[clickhouse_complex_mixed_key_cache] 0.00s setup test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_secure_cluster[nopass-] 0.00s teardown test_dictionaries_all_layouts_separate_sources/test_http.py::test_complex[complex_key_hashed] 0.00s setup test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_secure_cluster[pass-foo] 0.00s setup test_dictionaries_select_all/test.py::test_select_all[clickhouse_range_hashed] 0.00s teardown test_dictionaries_all_layouts_separate_sources/test_executable_cache.py::test_complex[complex_key_cache] 0.00s setup test_dictionaries_all_layouts_separate_sources/test_http.py::test_simple[hashed] 0.00s setup test_alter_moving_garbage/test.py::test_delete_race_leftovers 0.00s teardown test_dictionaries_all_layouts_separate_sources/test_http.py::test_simple[flat] 0.00s setup test_dictionaries_all_layouts_separate_sources/test_executable_cache.py::test_simple[cache] 0.00s teardown test_dictionaries_all_layouts_separate_sources/test_http.py::test_simple[cache] 0.00s setup test_concurrent_ttl_merges/test.py::test_limited_ttl_merges_in_empty_pool_replicated 0.00s setup test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_secure_cluster[pass-foo] 0.00s setup test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_insecure_cluster[pass-foo] 0.00s teardown test_attach_backup_from_s3_plain/test.py::test_attach_part[compact1] 0.00s setup test_distributed_inter_server_secret/test.py::test_secure_cluster_distributed_over_distributed_different_users_cluster 0.00s setup test_dictionaries_all_layouts_separate_sources/test_http.py::test_simple[cache] 0.00s setup test_alter_moving_garbage/test.py::test_alter_moving[False-True] 0.00s setup test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_secure_cluster[nopass-] 0.00s setup test_dictionaries_select_all/test.py::test_select_all[clickhouse_flat] 0.00s setup test_distributed_inter_server_secret/test.py::test_insecure_insert_sync 0.00s setup test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_secure_cluster[default-] 0.00s setup test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_insecure_cluster[nopass-] 0.00s teardown test_dictionaries_all_layouts_separate_sources/test_http.py::test_simple[direct] 0.00s teardown test_compatibility_merge_tree_settings/test.py::test_check_projections_compatibility 0.00s teardown test_default_role/test.py::test_alter_user 0.00s setup test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_insecure_cluster[default-] 0.00s setup test_alter_moving_garbage/test.py::test_alter_moving[True-True] 0.00s teardown test_cow_policy/test.py::test_cow_policy[cow_policy_multi_disk] 0.00s setup test_disks_app_interactive/test.py::test_disks_app_interactive_list_files_local 0.00s teardown test_alter_moving_garbage/test.py::test_alter_moving[True-True] 0.00s setup test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_insecure_cluster[pass-foo] 0.00s setup test_dictionaries_all_layouts_separate_sources/test_http.py::test_simple[flat] 0.00s teardown test_dictionaries_mysql/test.py::test_mysql_dictionaries_custom_query_full_load 0.00s setup test_backup_restore_on_cluster/test_cancel_backup.py::test_long_disconnection_stops_backup 0.00s setup test_disks_app_interactive/test.py::test_disks_app_interactive_list_directories_default 0.00s setup test_concurrent_ttl_merges/test.py::test_limited_ttl_merges_two_replicas 0.00s setup test_check_table_name_length/test.py::test_check_table_name_length 0.00s setup test_cow_policy/test.py::test_cow_policy[cow_policy_multi_volume] 0.00s teardown test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_secure_cluster[nopass-] 0.00s teardown test_dictionaries_mysql/test.py::test_background_dictionary_reconnect 0.00s teardown test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_insecure_cluster[nopass-] 0.00s teardown test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_secure_cluster[default-] 0.00s teardown test_dictionaries_select_all/test.py::test_select_all[clickhouse_flat] 0.00s teardown test_dictionaries_select_all/test.py::test_select_all_from_cached[clickhouse_complex_integers_key_cache] 0.00s teardown test_disks_app_interactive/test.py::test_disks_app_interactive_cp_and_read 0.00s teardown test_disk_types/test.py::test_different_types 0.00s teardown test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_secure_cluster[pass-foo] 0.00s teardown test_dictionaries_mysql/test.py::test_mysql_dictionaries_custom_query_partial_load_simple_key 0.00s teardown test_attach_backup_from_s3_plain/test.py::test_attach_part[wide0] 0.00s teardown test_default_role/test.py::test_set_default_roles 0.00s setup test_dictionaries_mysql/test.py::test_mysql_dictionaries_custom_query_partial_load_simple_key 0.00s setup test_dictionaries_mysql/test.py::test_mysql_dictionaries_custom_query_full_load 0.00s setup test_disk_types/test.py::test_select_by_type 0.00s setup test_buffer_profile/test.py::test_default_profile 0.00s teardown test_custom_settings/test.py::test_custom_settings 0.00s teardown test_dictionaries_select_all/test.py::test_select_all_from_cached[clickhouse_cache] 0.00s setup test_custom_settings/test.py::test_illformed_setting 0.00s setup test_disks_app_interactive/test.py::test_disks_app_interactive_test_move_and_write 0.00s teardown test_dictionaries_all_layouts_separate_sources/test_http.py::test_ranged[range_hashed] 0.00s teardown test_distributed_inter_server_secret/test.py::test_secure 0.00s teardown test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_secure_cluster[default-] 0.00s teardown test_alter_moving_garbage/test.py::test_alter_moving[False-True] 0.00s teardown test_buffer_profile/test.py::test_buffer_profile 0.00s setup test_disks_app_interactive/test.py::test_disks_app_interactive_list_disks 0.00s teardown test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_secure_cluster[pass-foo] 0.00s teardown test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_insecure_cluster[pass-foo] 0.00s teardown test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_insecure_cluster[default-] 0.00s teardown test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_insecure_cluster[default-] 0.00s teardown test_distributed_inter_server_secret/test.py::test_insecure_insert_async 0.00s teardown test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_secure_cluster[nopass-] 0.00s teardown test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_insecure_cluster[nopass-] 0.00s teardown test_distributed_inter_server_secret/test.py::test_insecure_insert_sync 0.00s teardown test_dictionaries_select_all/test.py::test_select_all[clickhouse_complex_mixed_key_hashed] 0.00s teardown test_disks_app_interactive/test.py::test_disks_app_interactive_list_disks 0.00s teardown test_dictionaries_mysql/test.py::test_mysql_dictionaries_custom_query_partial_load_complex_key 0.00s teardown test_disks_app_interactive/test.py::test_disks_app_interactive_test_move_and_write 0.00s teardown test_disks_app_interactive/test.py::test_disks_app_interactive_list_files_local 0.00s teardown test_disks_app_interactive/test.py::test_disks_app_interactive_list_directories_default =========================== short test summary info ============================ FAILED test_backup_restore_on_cluster/test_cancel_backup.py::test_shutdown_cancels_backup FAILED test_cow_policy/test.py::test_cow_policy[cow_policy_multi_disk] - Exce... FAILED test_cow_policy/test.py::test_cow_policy[cow_policy_multi_volume] - Ex... PASSED test_disks_app_interactive/test.py::test_disks_app_interactive_cp_and_read PASSED test_disks_app_interactive/test.py::test_disks_app_interactive_list_directories_default PASSED test_disks_app_interactive/test.py::test_disks_app_interactive_list_disks PASSED test_disks_app_interactive/test.py::test_disks_app_interactive_list_files_local PASSED test_disks_app_interactive/test.py::test_disks_app_interactive_test_move_and_write PASSED test_dictionaries_select_all/test.py::test_select_all[clickhouse_complex_integers_key_hashed] PASSED test_dictionaries_select_all/test.py::test_select_all[clickhouse_complex_mixed_key_hashed] PASSED test_default_role/test.py::test_alter_user PASSED test_dictionaries_select_all/test.py::test_select_all[clickhouse_flat] PASSED test_dictionaries_select_all/test.py::test_select_all[clickhouse_hashed] PASSED test_attach_backup_from_s3_plain/test.py::test_attach_part[compact0] PASSED test_dictionaries_select_all/test.py::test_select_all[clickhouse_range_hashed] PASSED test_attach_backup_from_s3_plain/test.py::test_attach_part[compact1] PASSED test_default_role/test.py::test_set_default_roles PASSED test_attach_backup_from_s3_plain/test.py::test_attach_part[wide0] PASSED test_dictionaries_select_all/test.py::test_select_all_from_cached[clickhouse_cache] PASSED test_default_role/test.py::test_wrong_set_default_role PASSED test_attach_backup_from_s3_plain/test.py::test_attach_part[wide1] PASSED test_dictionaries_select_all/test.py::test_select_all_from_cached[clickhouse_complex_integers_key_cache] PASSED test_allowed_client_hosts/test.py::test_allowed_host PASSED test_dictionaries_select_all/test.py::test_select_all_from_cached[clickhouse_complex_mixed_key_cache] PASSED test_allowed_client_hosts/test.py::test_denied_host PASSED test_distributed_inter_server_secret/test.py::test_insecure PASSED test_backup_restore_on_cluster/test_cancel_backup.py::test_cancel_backup PASSED test_distributed_inter_server_secret/test.py::test_insecure_insert_async PASSED test_alter_moving_garbage/test.py::test_alter_moving[False-False] PASSED test_concurrent_ttl_merges/test.py::test_limited_ttl_merges_in_empty_pool PASSED test_dictionaries_all_layouts_separate_sources/test_http.py::test_complex[complex_key_cache] PASSED test_distributed_inter_server_secret/test.py::test_insecure_insert_sync PASSED test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_insecure_cluster[default-] PASSED test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_insecure_cluster[nopass-] PASSED test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_insecure_cluster[pass-foo] PASSED test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_secure_cluster[default-] PASSED test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_secure_cluster[nopass-] PASSED test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_secure_cluster[pass-foo] PASSED test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_insecure_cluster[default-] PASSED test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_insecure_cluster[nopass-] PASSED test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_insecure_cluster[pass-foo] PASSED test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_secure_cluster[default-] PASSED test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_secure_cluster[nopass-] PASSED test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_secure_cluster[pass-foo] PASSED test_distributed_inter_server_secret/test.py::test_secure PASSED test_buffer_profile/test.py::test_buffer_profile PASSED test_buffer_profile/test.py::test_default_profile PASSED test_distributed_inter_server_secret/test.py::test_secure_cluster_distributed_over_distributed_different_users_cluster PASSED test_alter_moving_garbage/test.py::test_alter_moving[False-True] PASSED test_dictionaries_mysql/test.py::test_background_dictionary_reconnect PASSED test_dictionaries_mysql/test.py::test_mysql_dictionaries_custom_query_full_load PASSED test_dictionaries_mysql/test.py::test_mysql_dictionaries_custom_query_partial_load_complex_key PASSED test_dictionaries_mysql/test.py::test_mysql_dictionaries_custom_query_partial_load_simple_key PASSED test_dictionaries_mysql/test.py::test_predefined_connection_configuration PASSED test_alter_moving_garbage/test.py::test_alter_moving[True-True] PASSED test_dictionaries_all_layouts_separate_sources/test_http.py::test_complex[complex_key_direct] PASSED test_check_table_name_length/test.py::test_backward_compatibility PASSED test_check_table_name_length/test.py::test_check_table_name_length PASSED test_compatibility_merge_tree_settings/test.py::test_check_projections_compatibility PASSED test_compatibility_merge_tree_settings/test.py::test_config_overrides_compatibility PASSED test_dictionaries_all_layouts_separate_sources/test_http.py::test_complex[complex_key_hashed] PASSED test_backup_restore_on_cluster/test_cancel_backup.py::test_cancel_restore PASSED test_custom_settings/test.py::test_custom_settings PASSED test_custom_settings/test.py::test_illformed_setting PASSED test_disk_types/test.py::test_different_types PASSED test_backward_compatibility/test_aggregate_fixed_key.py::test_two_level_merge PASSED test_disk_types/test.py::test_select_by_type PASSED test_dictionaries_all_layouts_separate_sources/test_http.py::test_ranged[range_hashed] PASSED test_backup_restore_on_cluster/test_cancel_backup.py::test_error_leaves_no_trash PASSED test_dictionaries_all_layouts_separate_sources/test_executable_cache.py::test_complex[complex_key_cache] PASSED test_backward_compatibility/test_cte_distributed.py::test_cte_distributed PASSED test_dictionaries_all_layouts_separate_sources/test_http.py::test_simple[cache] PASSED test_dictionaries_all_layouts_separate_sources/test_executable_cache.py::test_simple[cache] PASSED test_cleanup_after_start/test.py::test_old_dirs_cleanup PASSED test_alter_moving_garbage/test.py::test_delete_race_leftovers PASSED test_backup_restore_on_cluster/test_cancel_backup.py::test_long_disconnection_stops_backup PASSED test_backward_compatibility/test_short_strings_aggregation.py::test_backward_compatability PASSED test_dictionaries_all_layouts_separate_sources/test_http.py::test_simple[direct] PASSED test_compression_nested_columns/test.py::test_nested_compression_codec PASSED test_backup_restore_on_cluster/test_cancel_backup.py::test_short_disconnection_doesnt_stop_backup PASSED test_concurrent_ttl_merges/test.py::test_limited_ttl_merges_in_empty_pool_replicated PASSED test_concurrent_queries_for_user_restriction/test.py::test_exception_message PASSED test_dictionaries_all_layouts_separate_sources/test_http.py::test_simple[flat] PASSED test_backup_log/test.py::test_backup_log PASSED test_config_xml_main/test.py::test_xml_main_conf PASSED test_backup_restore_on_cluster/test_cancel_backup.py::test_short_disconnection_doesnt_stop_restore PASSED test_dictionaries_all_layouts_separate_sources/test_http.py::test_simple[hashed] PASSED test_backup_restore_new/test_shutdown_wait_backup.py::test_shutdown_wait_backup PASSED test_backward_compatibility/test_ip_types_binary_compatibility.py::test_ip_types_binary_compatibility PASSED test_cluster_discovery/test_auxiliary_keeper.py::test_cluster_discovery_with_auxiliary_keeper_startup_and_stop PASSED test_config_reloader_interval/test.py::test_reload_config PASSED test_cluster_discovery/test_password.py::test_connect_with_password PASSED test_backward_compatibility/test_convert_ordinary.py::test_convert_ordinary_to_atomic PASSED test_concurrent_ttl_merges/test.py::test_limited_ttl_merges_two_replicas PASSED test_concurrent_ttl_merges/test.py::test_no_ttl_merges_in_busy_pool PASSED test_backward_compatibility/test_memory_bound_aggregation.py::test_backward_compatability PASSED test_config_yaml_merge_keys/test.py::test_yaml_merge_keys_conf PASSED test_ddl_worker_replicas/test.py::test_ddl_worker_replicas PASSED test_ddl_alter_query/test.py::test_alter PASSED test_ddl_alter_query/test.py::test_ddl_queue_hostname_change =================== 3 failed, 97 passed in 429.49s (0:07:09) =================== Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration/./runner", line 492, in subprocess.check_call(cmd, shell=True, bufsize=0) File "/usr/lib/python3.10/subprocess.py", line 369, in check_call raise CalledProcessError(retcode, cmd) subprocess.CalledProcessError: Command 'docker run --rm --name clickhouse_integration_tests_tda2mg --privileged --dns-search='.' --memory=30709030912 --security-opt seccomp=unconfined --cap-add=SYS_PTRACE --volume=/home/ubuntu/_work/_temp/test/build/clickhouse:/clickhouse --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/programs/server:/clickhouse-config --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration:/ClickHouse/tests/integration --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/backupview:/ClickHouse/utils/backupview --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/grpc-client/pb2:/ClickHouse/utils/grpc-client/pb2 --volume=/run:/run/host:ro --volume=clickhouse_integration_tests_volume:/var/lib/docker -e DOCKER_DOTNET_CLIENT_TAG=11de0b29a15d -e DOCKER_HELPER_TAG=5dc43a6382f0 -e DOCKER_BASE_TAG=5ccda723c1fc -e DOCKER_KERBEROS_KDC_TAG=9391ecdee8d7 -e DOCKER_MYSQL_GOLANG_CLIENT_TAG=9bec2a638e6e -e DOCKER_MYSQL_JAVA_CLIENT_TAG=766bff31cfe4 -e DOCKER_MYSQL_JS_CLIENT_TAG=41ba7c2ec2a1 -e DOCKER_MYSQL_PHP_CLIENT_TAG=88be89c1e3b6 -e DOCKER_NGINX_DAV_TAG=b55ac9cd7519 -e DOCKER_POSTGRESQL_JAVA_CLIENT_TAG=a4eff5c7f4d6 -e DOCKER_PYTHON_BOTTLE_TAG=d862517635bf -e DOCKER_CLIENT_TIMEOUT=300 -e COMPOSE_HTTP_TIMEOUT=600 -e PYTHONUNBUFFERED=1 -e PYTEST_ADDOPTS="--dist=loadfile -n 10 -rfEps --run-id=0 --color=no --durations=0 --report-log=parallel0_0.jsonl --report-log-exclude-logs-on-passed-tests test_allowed_client_hosts/test.py::test_allowed_host test_allowed_client_hosts/test.py::test_denied_host 'test_alter_moving_garbage/test.py::test_alter_moving[False-False]' 'test_alter_moving_garbage/test.py::test_alter_moving[False-True]' 'test_alter_moving_garbage/test.py::test_alter_moving[True-True]' test_alter_moving_garbage/test.py::test_delete_race_leftovers 'test_attach_backup_from_s3_plain/test.py::test_attach_part[compact0]' 'test_attach_backup_from_s3_plain/test.py::test_attach_part[compact1]' 'test_attach_backup_from_s3_plain/test.py::test_attach_part[wide0]' 'test_attach_backup_from_s3_plain/test.py::test_attach_part[wide1]' test_backup_log/test.py::test_backup_log test_backup_restore_new/test_shutdown_wait_backup.py::test_shutdown_wait_backup test_backup_restore_on_cluster/test_cancel_backup.py::test_cancel_backup test_backup_restore_on_cluster/test_cancel_backup.py::test_cancel_restore test_backup_restore_on_cluster/test_cancel_backup.py::test_error_leaves_no_trash test_backup_restore_on_cluster/test_cancel_backup.py::test_long_disconnection_stops_backup test_backup_restore_on_cluster/test_cancel_backup.py::test_short_disconnection_doesnt_stop_backup test_backup_restore_on_cluster/test_cancel_backup.py::test_short_disconnection_doesnt_stop_restore test_backup_restore_on_cluster/test_cancel_backup.py::test_shutdown_cancels_backup test_backward_compatibility/test_aggregate_fixed_key.py::test_two_level_merge test_backward_compatibility/test_convert_ordinary.py::test_convert_ordinary_to_atomic test_backward_compatibility/test_cte_distributed.py::test_cte_distributed test_backward_compatibility/test_ip_types_binary_compatibility.py::test_ip_types_binary_compatibility test_backward_compatibility/test_memory_bound_aggregation.py::test_backward_compatability test_backward_compatibility/test_short_strings_aggregation.py::test_backward_compatability test_buffer_profile/test.py::test_buffer_profile test_buffer_profile/test.py::test_default_profile test_check_table_name_length/test.py::test_backward_compatibility test_check_table_name_length/test.py::test_check_table_name_length test_cleanup_after_start/test.py::test_old_dirs_cleanup test_cluster_discovery/test_auxiliary_keeper.py::test_cluster_discovery_with_auxiliary_keeper_startup_and_stop test_cluster_discovery/test_password.py::test_connect_with_password test_compatibility_merge_tree_settings/test.py::test_check_projections_compatibility test_compatibility_merge_tree_settings/test.py::test_config_overrides_compatibility test_compression_nested_columns/test.py::test_nested_compression_codec test_concurrent_queries_for_user_restriction/test.py::test_exception_message test_concurrent_ttl_merges/test.py::test_limited_ttl_merges_in_empty_pool test_concurrent_ttl_merges/test.py::test_limited_ttl_merges_in_empty_pool_replicated test_concurrent_ttl_merges/test.py::test_limited_ttl_merges_two_replicas test_concurrent_ttl_merges/test.py::test_no_ttl_merges_in_busy_pool test_config_reloader_interval/test.py::test_reload_config test_config_xml_main/test.py::test_xml_main_conf test_config_yaml_merge_keys/test.py::test_yaml_merge_keys_conf 'test_cow_policy/test.py::test_cow_policy[cow_policy_multi_disk]' 'test_cow_policy/test.py::test_cow_policy[cow_policy_multi_volume]' test_custom_settings/test.py::test_custom_settings test_custom_settings/test.py::test_illformed_setting test_ddl_alter_query/test.py::test_alter test_ddl_alter_query/test.py::test_ddl_queue_hostname_change test_ddl_worker_replicas/test.py::test_ddl_worker_replicas test_default_role/test.py::test_alter_user test_default_role/test.py::test_set_default_roles test_default_role/test.py::test_wrong_set_default_role 'test_dictionaries_all_layouts_separate_sources/test_executable_cache.py::test_complex[complex_key_cache]' 'test_dictionaries_all_layouts_separate_sources/test_executable_cache.py::test_simple[cache]' 'test_dictionaries_all_layouts_separate_sources/test_http.py::test_complex[complex_key_cache]' 'test_dictionaries_all_layouts_separate_sources/test_http.py::test_complex[complex_key_direct]' 'test_dictionaries_all_layouts_separate_sources/test_http.py::test_complex[complex_key_hashed]' 'test_dictionaries_all_layouts_separate_sources/test_http.py::test_ranged[range_hashed]' 'test_dictionaries_all_layouts_separate_sources/test_http.py::test_simple[cache]' 'test_dictionaries_all_layouts_separate_sources/test_http.py::test_simple[direct]' 'test_dictionaries_all_layouts_separate_sources/test_http.py::test_simple[flat]' 'test_dictionaries_all_layouts_separate_sources/test_http.py::test_simple[hashed]' test_dictionaries_mysql/test.py::test_background_dictionary_reconnect test_dictionaries_mysql/test.py::test_mysql_dictionaries_custom_query_full_load test_dictionaries_mysql/test.py::test_mysql_dictionaries_custom_query_partial_load_complex_key test_dictionaries_mysql/test.py::test_mysql_dictionaries_custom_query_partial_load_simple_key test_dictionaries_mysql/test.py::test_predefined_connection_configuration 'test_dictionaries_select_all/test.py::test_select_all[clickhouse_complex_integers_key_hashed]' 'test_dictionaries_select_all/test.py::test_select_all[clickhouse_complex_mixed_key_hashed]' 'test_dictionaries_select_all/test.py::test_select_all[clickhouse_flat]' 'test_dictionaries_select_all/test.py::test_select_all[clickhouse_hashed]' 'test_dictionaries_select_all/test.py::test_select_all[clickhouse_range_hashed]' 'test_dictionaries_select_all/test.py::test_select_all_from_cached[clickhouse_cache]' 'test_dictionaries_select_all/test.py::test_select_all_from_cached[clickhouse_complex_integers_key_cache]' 'test_dictionaries_select_all/test.py::test_select_all_from_cached[clickhouse_complex_mixed_key_cache]' test_disk_types/test.py::test_different_types test_disk_types/test.py::test_select_by_type test_disks_app_interactive/test.py::test_disks_app_interactive_cp_and_read test_disks_app_interactive/test.py::test_disks_app_interactive_list_directories_default test_disks_app_interactive/test.py::test_disks_app_interactive_list_disks test_disks_app_interactive/test.py::test_disks_app_interactive_list_files_local test_disks_app_interactive/test.py::test_disks_app_interactive_test_move_and_write test_distributed_inter_server_secret/test.py::test_insecure test_distributed_inter_server_secret/test.py::test_insecure_insert_async test_distributed_inter_server_secret/test.py::test_insecure_insert_sync 'test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_insecure_cluster[default-]' 'test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_insecure_cluster[nopass-]' 'test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_insecure_cluster[pass-foo]' 'test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_secure_cluster[default-]' 'test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_secure_cluster[nopass-]' 'test_distributed_inter_server_secret/test.py::test_per_user_inline_settings_secure_cluster[pass-foo]' 'test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_insecure_cluster[default-]' 'test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_insecure_cluster[nopass-]' 'test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_insecure_cluster[pass-foo]' 'test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_secure_cluster[default-]' 'test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_secure_cluster[nopass-]' 'test_distributed_inter_server_secret/test.py::test_per_user_protocol_settings_secure_cluster[pass-foo]' test_distributed_inter_server_secret/test.py::test_secure test_distributed_inter_server_secret/test.py::test_secure_cluster_distributed_over_distributed_different_users_cluster -vvv " altinityinfra/integration-tests-runner:226bfaf75ac1 ' returned non-zero exit status 1.